php修改mysql密码centos_详解mysql在Centos下修改密码的方法

这篇文章主要介绍了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 ]