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 Vibe.
Make sure you have access to your operating system installation media.
In YaST, click Software > Software Management.
In the Search field, type mysql, then click Search.
Select mysql, then click Accept.
Click Continue to resolve dependencies.
Click Continue to acknowledge package support status.
MySQL is then installed from the SLES media.
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 Vibe:
In YaST, click System > System Services.
Scroll to and select the MySQL service, then click Enable.
Click Continue to install dependencies, then click OK to close the status box.
Click OK > Yes to finish the installation, 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 VIBE INSTALLATION SUMMARY SHEET |
|---|
|
Under Database Credentials on the Basic Vibe Installation Summary Sheet, specify the MySQL administrator password. The Vibe installation program prompts you for this information. |
The following table includes 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 through 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 Windows Essentials line, click Download.
Click Save File, browse to and select a convenient temporary directory, then click Save.
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 online instructions to install the MySQL software on the Windows server, then continue with Step 8 to configure the server.
Unless you are already familiar with configuring MySQL on a Windows server, select Standard Configuration, then click Next.
Select Include Bin Directory in Windows PATH, then click Next.
Set the MySQL root user password, then click Next.
|
BASIC VIBE INSTALLATION SUMMARY SHEET |
|---|
|
Under Database Credentials on the Basic Vibe Installation Summary Sheet, specify the MySQL administrator password. The Vibe installation program prompts you for this information. |
Click Execute to configure the MySQL database server, then click Finish.
Some messages report the status of your MySQL installation.
To monitor the MySQL database server, click Start > All Programs, then click MySQL > MySQL Server 5.1 > MySQL Command Line Client.