1 修改 /etc/my.cnf
加上
[mysqld]
skip-grant-tables
2. 重启mysql
service mysql restart
3. 更改root密码
mysql> USE mysql ;
mysql> UPDATE user SET Password = password ( 'new-password' ) WHERE User = 'root' ;
mysql> flush privileges ;
mysql> quit
如果版本高于5.6 则是如下字段存着密码
authentication_string
