1在 /etc/my.cnf 的 [mysqld] 添加skip-grant-tables=1
2重启 数据库systemctl restart mysqld
3 修改密码
use mysql
update user set authentication_string=password("123456") where user="root";
FLUSH PRIVILEGES;
1在 /etc/my.cnf 的 [mysqld] 添加skip-grant-tables=1
2重启 数据库systemctl restart mysqld
3 修改密码
use mysql
update user set authentication_string=password("123456") where user="root";
FLUSH PRIVILEGES;
转载于:https://my.oschina.net/u/2446173/blog/3081319