[root@firewall \/]# \/etc\/init.d\/mysqld stop
\nStopping mysqld: [ OK ]
\n[root@firewall \/]# mysqld_safe –skip-grant-tables &
\n[1] 3489
\n[root@firewall \/]# 120525 16:11:52 mysqld_safe Logging to ‘\/var\/log\/mysqld.log’.
\n120525 16:11:53 mysqld_safe Starting mysqld daemon with databases from \/var\/lib\/mysql<\/p>\n
[root@firewall \/]# mysql
\nWelcome to the MySQL monitor. Commands end with ; or \\g.
\nYour MySQL connection id is 1
\nServer version: 5.1.61 Source distribution<\/p>\n
Copyright (c) 2000, 2011, Oracle and\/or its affiliates. All rights reserved.<\/p>\n
Oracle is a registered trademark of Oracle Corporation and\/or its
\naffiliates. Other names may be trademarks of their respective
\nowners.<\/p>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/p>\n
mysql> use mysql;
\nReading table information for completion of table and column names
\nYou can turn off this feature to get a quicker startup with -A<\/p>\n
Database changed
\nmysql> update user set password = password(‘123456′) where user=’root’ and host=’localhost’;
\nQuery OK, 0 rows affected (0.00 sec)
\nRows matched: 1 Changed: 0 Warnings: 0<\/p>\n
mysql> flush privileges;
\nQuery OK, 0 rows affected (0.00 sec)<\/p>\n
mysql> quit;
\nBye
\n[root@firewall \/]# \/etc\/init.d\/mysqld restart
\n120525 16:12:34 mysqld_safe mysqld from pid file \/var\/run\/mysqld\/mysqld.pid ended
\nStopping mysqld: [ OK ]
\nStarting mysqld: [ OK ]
\n[1]+ Done mysqld_safe –skip-grant-tables
\n[root@firewall \/]#<\/p>\n