>>>>
| Key_write_requests | 1329608 |
| Key_writes | 804229 |
| Last_query_cost | 0.000000 |
| Max_used_connections | 388 |
| Ndb_cluster_node_id | 0 |
| Ndb_config_from_host | |
| Ndb_config_from_port | 0 |
| Ndb_number_of_data_nodes | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 1297 |
| Open_streams | 0 |
| Open_tables | 776 |
| Opened_tables | 1022 |
| Prepared_stmt_count | 0 |
| Qcache_free_blocks | 4717 |
| Qcache_free_memory | 31434976 |
| Qcache_hits | 61849890 |
| Qcache_inserts | 751599 |
| Qcache_lowmem_prunes | 11171 |
| Qcache_not_cached | 601714 |
| Qcache_queries_in_cache | 10884 |
| Qcache_total_blocks | 27139 |
| Queries | 377230178 |
| Questions | 377230178 |
| Rpl_status | NULL |
| Select_full_join | 239 |
| Select_full_range_join | 10 |
| Select_range | 5031 |
| Select_range_check | 5 |
| Select_scan | 722781 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 471921 |
| Sort_merge_passes | 15 |
| Sort_range | 36729 |
| Sort_rows | 4948223 |
| Sort_scan | 202518 |
| Table_locks_immediate | 1417366 |
| Table_locks_waited | 73845 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 281 |
| Threads_connected | 5 |
| Threads_created | 388 |
| Threads_running | 3 |
| Uptime | 71968 |

For Redhat Linux users, use the following instructions as the root user of Redhat Linux machine:

1. Stop MySQL process by using command:

# killall mysqld
2. Start the MySQL server with following options:

# /usr/libexec/mysqld -Sg –user=root &
3. Start the MySQL client:

# mysql

You should see the following message:

Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 3.xx.xx

Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the buffer.

mysql>
4. Use mysql database:

mysql> USE mysql

You should see the following message:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
5. Then, update the password for the root user with the following command:

UPDATE user SET password=password(”newpassword”) WHERE user=”root”;

Replace newpassword with your desired password. You should see the following message:

Query OK, 2 rows affected (0.03 sec)
Rows matched: 2 Changed: 2 Warnings: 0

Rows affected may be different, but the Query OK should be there.
6. Flush the database privileges to reload it in order to make the changes effective:

mysql> flush privileges;

You should get the following result:

Query OK, 0 rows affected (0.02 sec)
7. Exit the MySQL client by typing exit.
8. Kill the MySQL server process by typing killall mysqld.
9. Then start MySQL again:

/etc/init.d/mysqld start