查看初始密码
grep 'temporary password' /var/log/mysqld.log
cat /root/.mysql_secret
mysql密码找回
密码重置
vi /etc/f
在[mysqld]下加上 skip-grant-tables,如:
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock skip-grant-tables
重启mysql
service mysqld restart
登陆mysql后就可以修改密码了
mysql -u root
update mysql.user set authentication_string=PASSWORD('123456') where User='root';
flush privileges;
参考文献:/p/0a40cbaa79a0