Centos7 安装mysql 8.0.13(rpm)的步骤,就看这一篇就可以
linux mysql8.0 修改密码
1.免密登陆
vim /etc/my.cnf
[mysqld] 添加
skip-grant-tables
2.mysql -uroot
3.修改密码
use mysql;
update user set authentication_string=’’ where user=‘root’;
ALTER user ‘root’@‘localhost’ IDENTIFIED BY ‘123456’;
navicat连接报错 1251
1.登陆mysql mysql -uroot -pxxxx
2.更改加密方式
ALTER USER ‘root’@’%’ IDENTIFIED BY ‘xxxxx’ PASSWORD EXPIRE NEVER;
3.更改密码
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘xxx’;