修改mysql的root密码

brian_kwong

修改mysql的root密码

1，关闭mysql服务
[root@localhost ~]# service mysql stop
Shutting down MySQL..                                      [  OK  ]
[root@localhost ~]#

2，跳过授权表启动mysql,关闭网络监听，让其后台运行或者开个新终端。
[root@localhost ~]# mysqld_safe --skip-grant-tables --skip-networking
090411 15:57:20 mysqld_safe Logging to '/var/lib/mysql/localhost.localdomain.err'.
090411 15:57:20 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[1]+  Stopped                 mysqld_safe --skip-grant-tables --skip-networking
[root@localhost ~]# bg
[1]+ mysqld_safe --skip-grant-tables --skip-networking &
3,链接mysql服务器
[root@localhost ~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.32-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>

4,使用mysql数据库
mysql> use mysql;
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
mysql>

5,重设密码
mysql> update user set password=password('123') where user='root';
Query OK, 3 rows affected (0.00 sec)
Rows matched: 3  Changed: 3  Warnings: 0
mysql>

6,重启mysql服务
[root@localhost ~]# service mysql restart
Shutting down MySQL..090411 15:59:50 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended
                                                           [  OK  ]
Starting MySQL.                                            [  OK  ]
[1]+  Done                    mysqld_safe --skip-grant-tables --skip-networking
[root@localhost ~]#

7，再次登陆成功
[root@localhost ~]# mysql -uroot -p123
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.32-community MySQL Community Server (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u3/94265/showart_1898215.html