A.2 MySQL Database Server

A.2.1 MySQL on Linux

Depending on the options you select when installing Open Enterprise Server 2 and SUSE Linux Enterprise Server (SLES), the MySQL 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 database server. If MySQL is already installed, you still need to configure it for use with Teaming.

Installing MySQL

  1. Make sure 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.

Configuring MySQL

When MySQL 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 database server for use with Teaming:

  1. In YaST, click System > System Services.

  2. Scroll to and select the MySQL 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 MySQL database server has started, use the following command:

    ps -eaf | grep mysql

    You should see MySQL processes running.

  7. Set the administrator password for the MySQL database server:

    mysqladmin -u root password new_password

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

    IMPORTANT:The MySQL root username 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 MySQL root user needs to have a password established for it when you install MySQL.

BASIC TEAMING INSTALLATION SUMMARY SHEET

Under Database Credentials on the Basic Teaming Installation Summary Sheet, specify the MySQL administrator password. The Teaming Installation program prompts you for this information.

Learning More about MySQL

The following are some basic and useful MySQL commands:

Action

Command

Stop MySQL

 
/etc/initd/mysql stop

Start MySQL

 
/etc/initd/mysql start

Show MySQL status

 
mysqladmin -u root -p extended-status

If you want to administer MySQL using a GUI interface, you can download tools from:

MySQL GUI Tools Downloads

For more information about MySQL, see:

MySQL Documentation

A.2.2 MySQL on Windows

  1. In your Web browser, go to the following URL:

    MySQL 5.1 Downloads

  2. Scroll down if necessary, then click the type of Windows operating system you are using (32-bit or 64-bit).

  3. On the Windows Essentials line, click Download.

  4. Click Save File, browse to and select a convenient temporary directory, then click Save.

  5. In Windows Explorer, browse to the directory where you saved the MySQL .exe file.

  6. Double-click the MySQL .exe file to start the MySQL Setup Wizard.

  7. Follow the on-line instructions to install the MySQL software on the Windows server, then continue with configuring the server.

  8. Unless you are already familiar with configuring MySQL on a Windows server, select Standard Configuration, then click Next.

  9. Select Include Bin Directory in Windows PATH, then click Next.

  10. Set the MySQL root user password, then click Next.

    BASIC TEAMING INSTALLATION SUMMARY SHEET

    Under Database Credentials on the Basic Teaming Installation Summary Sheet, specify the MySQL administrator password. The Teaming Installation program prompts you for this information.

  11. Click Execute to configure the MySQL database server, then click Finish.

    Some messages report the status of your MySQL installation.

  12. To monitor the MySQL database server, click Start > All Programs, then click MySQL > MySQL Server 5.1 > MySQL Command Line Client.