修改mysql密码

1.修改MySQL的登录设置：

# vim /etc/my.cnf 

在[mysqld]的段中加上一句：skip-grant-tables
例如：

[mysqld] 
datadir=/var/lib/mysql 
socket=/var/lib/mysql/mysql.sock 
skip-grant-tables 

保存并且退出vi。

2．重新启动mysqld

# service mysqld restart 

Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]

3．登录并修改MySQL的root密码

# mysql 

4.先通过flush privileges操作触发权限表的加载，再使用alter user语句修改root用户的密码

mysql> alter user 'root'@'localhost' identified by '123';
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> alter user 'root'@'localhost' identified by '123';
Query OK, 0 rows affected (0.00 sec)
mysql> quit

5.将MySQL的登录设置修改回来

# vim /etc/my.cnf 

将刚才在[mysqld]的段中加上的skip-grant-tables删除
保存并且退出vim

6．重新启动mysqld

# service mysqld restart 

Stopping MySQL: [ OK ]
Starting MySQL: [ OK ]