关闭Mysql 服务
service mysqld stop
启动mysqld_safe ,跳过启动授权表。启动时加上skip-grant-tables参数目的是在启动mysql时不启动grant-tables,
授权表。这样就可以修改root的密码了。mysqld_safe --skip-grant-tables &
登录mysql,回车目前密码是空
mysql -uroot -p
use mysql;
update mysql.user set authentication_string=password('123456') where user='root'; (适用于Mysql 5.7.11)
update user set password=PASSWORD('12345678') where user="root"; (适用于Mysql5.6)
flush privileges;
exit