Centos下 修改mysql密码的方法

1．修改mysql的登录设置：

# vim /etc/my.cnf

加上一句：skip-grant-tables

如：

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

2．重启mysql

# service mysqld restart
stopping mysql: [ ok ]
starting mysql: [ ok ]

3．修改密码

mysql> use mysql ;
database changed
mysql> update user set password = password ( '新密码' ) where user = 'root' ;
query ok, 0 rows affected (0.00 sec)
rows matched: 2 changed: 0 warnings: 0
mysql> flush privileges ;
query ok, 0 rows affected (0.01 sec)
mysql> quit

4．修改刚刚改过的配置文件

# vim /etc/my.cnf

5.重启mysql

# service mysqld restart
stopping mysql: [ ok ]
starting mysql: [ ok ]

以上所述是小编给大家介绍的centos下 修改mysql密码的方法，希望对大家有所帮助