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

2. If an older version of the MySQL software exists, remove it by entering the following
command:
# rpm –e package_name
NOTE: Because dependent relationships exist between RPM packages, you might encounter
errors such as error: Failed dependencies. If this error message is displayed, you
must first remove the dependent packages before proceeding with removal of the MySQL
software.
Installing MySQL
Install all the MySQL components listed in Table 3 using the appropriate version, displayed as
5.0.40-0.rhel5.<arch>.
Table 3 MySQL Components
DescriptionMySQL Component
MySQL server package
MySQL-server-pro-cert
MySQL client package
MySQL-client-pro-cert
MySQL development libraries package
MySQL-devel-pro-cert
MySQL shared libraries
MySQL-shared-pro-cert
MySQL Test Suite
MySQL-test-pro-cert
1. Install each MySQL package by entering the following command while logged in to the
target system as the root user:
rpm –ivh package_name
For example:
# rpm –ivh MySQL-client-enterprise-gpl-5.0.40-0.rhel5.x86_64.rpm
2. Verify that the MySQL server is running by entering the following command:
# mysqladmin version
3. Enter the following commands to verify that you can retrieve information from the MySQL
server:
# mysqlshow
# mysqlshow mysql
For more information about installing Linux RPMs, see “Installing MySQL on Linux” in the
MySQL 5.0 Reference Manual, located at:
http://dev.mysql.com/doc/refman/5.0/en/linux-rpm.html
Configuring MySQL
After the MySQL installation is complete, perform the following essential configuration steps to
optimize the installation.
MySQL creates a database server account named root during the installation, which is the
superuser administrator account that has unlimited privileges to modify the MySQL system. By
default, the root user account's password is empty. Before using MySQL, secure the default
account by assigning a root password.
Installing and Configuring the MySQL Database 9