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.
In YaST, click
.In the mysql, then click .
field, typeSelect
, then click .Click
to resolve dependencies.Click
to acknowledge package support status.MySQL is then installed from the SLES 11 media.
Continue with Configuring MySQL.
In your Web browser, go to the following URL:
Scroll down, then click the type of Linux operating system you are using.
Click
on the line.Save the .tar.gz file to a convenient temporary directory.
Extract the contents of the file, then install the MySQL database server software.
Repeat Step 3 through Step 5 for the line to download and install the MySQL client.
Continue with 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:
In YaST, click
.Scroll to and select the MySQL service, then click
.Click
to install dependencies, then click to close the status box.Click
, then exit YaST.In a terminal window, become the root user.
To verify that the MySQL database server has started, use the following command:
ps -eaf | grep mysql
You should see MySQL processes running.
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 Basic Teaming Installation Summary Sheet, specify the MySQL administrator password. The Teaming Installation program prompts you for this information. on the |
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:
For more information about MySQL, see:
In your Web browser, go to the following URL:
Scroll down if necessary, then click the type of Windows operating system you are using (32-bit or 64-bit).
On the
line, click .Click
, browse to and select a convenient temporary directory, then click .In Windows Explorer, browse to the directory where you saved the MySQL .exe file.
Double-click the MySQL .exe file to start the MySQL Setup Wizard.
Follow the on-line instructions to install the MySQL software on the Windows server, then continue with configuring the server.
Unless you are already familiar with configuring MySQL on a Windows server, select
, then click .Select
, then click .Set the MySQL root user password, then click
.
BASIC TEAMING INSTALLATION SUMMARY SHEET |
---|
Under Basic Teaming Installation Summary Sheet, specify the MySQL administrator password. The Teaming Installation program prompts you for this information. on the |
Click
to configure the MySQL database server, then click .Some messages report the status of your MySQL installation.
To monitor the MySQL database server, click
, then click .