HP OSMS Blueprint: Database Server on HP Server Platforms with MySQL and RHEL5

1. To assign a password to the root account, enter the following command:

# mysqladmin -u root -p password 'your_password'

NOTE: The MySQL database maintains its own user names and passwords, distinct and

separate from the Linux operating system’s users and passwords. Therefore, the MySQL

root user account is not the same as the Linux system root account, and to enhance system

security, should not use the same password.

2. To specify other MySQL configurations, use a configuration file. The sample configuration

files are located in the /usr/share/doc/mysql directory. Select the appropriate

configuration file, based on your system's memory size, from the following list:

• my-huge.cnf– 1GB or more of memory

• my-innodb-heavy-4G.cnf– 4GB or more of memory, using only InnoDB tables

• my-large.cnf– Up to 512MB of memory

3. For the configuration examples in this document, you configure and validate both the

MyISAM and InnoDB storage engines. To do this, choose the appropriate system

configuration, then copy, edit, and rename the file /etc/my.cnf.