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

identified by 'password' ;

For example, enter the following:

mysql> grant all privileges on osmsdb.* to osmsuser@'%' \

identified by 'osmspass' ;

NOTE: The preceding command grants access to any table in the osmdb database for the

user osmsuser@% with the password osmpass, connecting from any host name.

In the command, the percent character (%) acts as a wildcard and grants access to the user

from any host name. A user in MySQL is identified by username@hostname. If you do

not provide a value for the hostname during the creation of the database, the default value

is any host (@%).

Similarly, a value of %.%.%.% matches any IP address, such as 192.168.0.2 or 10.200.1.65.

For more information about the grant command, see “MySQL Access System” in the MySQL

5.0 Reference Manual located at:

http://dev.mysql.com/doc/refman/5.0/en/privilege-system.html

3. Immediately after granting a database user permissions, activate the permissions by entering

the following:

mysql> flush privileges;

Verifying Database Operation

System administrators can query the MySQL server to obtain a number of current status values,

which indicate basic health and performance, by running the following mysqladmin command:

# mysqladmin –u root –p status

At the prompt, enter the database password.

Figure 2 shows the results.

Figure 2 Check Basic Status Values

Alternatively, enter the following mysqladmin command to view a more detailed status report:

# mysqladmin –u root –p extended-status

Figure 3 shows the results.