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 2 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.
Ensure 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/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:
In YaST, click System > System Services.
Scroll to and select the 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 database server has started, use the following command:
ps -eaf | grep mysql
You should see the processes running.
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 Basic Vibe Installation Summary Sheet, specify the database administrator password. The Vibe installation program prompts you for this information. |
The following table includes some basic and useful MySQL or MariaDB 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 or MariaDB through a GUI interface, you can download tools from:
For more information about MySQL, see:
In your web browser, go to the MySQL or MariaDB download site.
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 .exe file to start the Setup Wizard.
Follow the online instructions to install the software on the Windows server, then continue with Step 8 to configure the server.
Unless you are already familiar with configuring MySQL or MariaDB on a Windows server, select Standard Configuration, then click Next.
Select Include Bin Directory in Windows PATH, then click Next.
Set the database root user password, then click Next.
|
BASIC VIBE INSTALLATION SUMMARY SHEET |
|---|
|
Under Database Credentials on the Basic Vibe Installation Summary Sheet, specify the database administrator password. The Vibe installation program prompts you for this information. |
Click Execute to configure the database server, then click Finish.
Some messages report the status of your installation.
To monitor the database server, click Start > All Programs, then click MySQL > MySQL Server 5.1 > MySQL Command Line Client or the equivalent MariaDB options.