10.1 MySQL (or MariaDB) on Linux

IMPORTANT:The steps in this section are optimized for installing MYSQL on SUSE Linux Enterprise Server (SLES) 11.

For information regarding the installation of MySQL on other versions of SLES or other flavors of Linux, see Installing and Upgrading MySQL in the MySQL documentation.

In SLES 12, the default database changed from MySQL to MariaDB. Installation and management procedures, etc. are basically unchanged. For information on installing SLES 12 and using MariaDB, see the SLES 12 Documentation and MariaDB web sites.

Depending on the options you select when installing Open Enterprise Server and SUSE Linux Enterprise Server (SLES), the MySQL or MariaDB database server might be installed along with the operating system. Check for the following directory:

/usr/bin/mysql

If the /usr/bin/mysql directory does not exist, you need to install the MySQL or MariaDB database server. If MySQL or MariaDB is already installed, you still need to configure it for use with Vibe.

10.1.1 Installing MySQL/MariaDB

  1. Ensure you have access to your operating system installation media.

  2. In YaST, click Software > Software Management.

  3. In the Search field, type mysql, then click Search.

  4. Select mysql, then click Accept.

  5. Click Continue to resolve dependencies.

  6. Click Continue to acknowledge package support status.

    MySQL is then installed from the SLES media.

  7. Continue with Configuring MySQL/MariaDB.

10.1.2 Configuring MySQL/MariaDB

When MySQL or MariaDB is initially installed, it is not configured with an administrator password, nor is it configured to start automatically. Follow the steps below to set up the MySQL or MariaDB database server for use with Vibe:

  1. In YaST, click System > System Services.

  2. Scroll to and select the service, then click Enable.

  3. Click Continue to install dependencies, then click OK to close the status box.

  4. Click OK > Yes to finish the installation, then exit YaST.

  5. In a terminal window, become the root user.

  6. To verify that the database server has started, use the following command:

    ps -eaf | grep mysql

    You should see the processes running.

  7. IMPORTANT:If you are installing MySQL 8, you must disable password complexity before setting the administrator password. Go to , complete the instructions there, then continue with Learning More about MySQL/MariaDB.

    Set the administrator password for the database server:

    mysqladmin -u root password new_password

    This command changes the password for the database root user, which is the default administrator user name for the MySQL or MariaDB database server. This command is part of the database client package.

    IMPORTANT:The database root user name is not the same as the Linux root user. The Linux root user has a password established for it when you install Linux. In a parallel fashion, the database root user needs to have a password established for it when you install MySQL or MariaDB.

BASIC VIBE INSTALLATION SUMMARY SHEET

Under Database Credentials on the Single-server Installation Planning Worksheet, specify the database administrator password. The Vibe installation program prompts you for this information.

10.1.3 Learning More about MySQL/MariaDB

The following table includes some basic and useful MySQL or MariaDB commands:

Action

Command

Stop MySQL

 
                      /etc/init.d/mysql stop

Start MySQL

 
                      /etc/init.d/mysql start

Show MySQL status

 
                      mysqladmin -u root -p extended-status

If you want to administer MySQL or MariaDB through a GUI interface, you can download tools from:

MySQL GUI Tools Downloads

For more information about MySQL, see:

MySQL Documentation