【Mysql】ROOT 密码重置

grep 'temporary password' /var/log/mysqld.log

# rm -rf /var/lib/mysql
# service mysqld restart 
# grep 'temporary password' /var/log/mysqld.log

# vi /etc/my.cnf

/* /etc/my.cnf */

...
[mysqld]
skip-grant-tables
...

# service restart mysqld

# mysql -u root

mysql> update mysql.user set authentication_string=password('密码') where user='root';
mysql> grant all privileges on *.* to 'root'@'%' identified by '密码';
mysql> flush privileges;
mysql> exit

# service restart mysqld