Ubuntu20.04安装mysql8.0

正常情况下mysql安装后,使用sudo mysql -u root -p,输入密码时直接回车就可以连接到mysql.

(如果无法连接到mysql,则先在/etc/mysql/mysql.conf.d/mysqld.cnf 的最末尾加上skip-grant-tables)

use mysql;
update user set authentication_string='' where user='root';（将密码置为空）
quit; 

 

如果之前加了skip-grant-tables,删掉/etc/mysql/mysql.conf.d/mysqld.cnf 最末尾的skip-grant-tables,重启mysql服务(sudo service mysql restart)

ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
flush privileges; 
quit;

如果修改的密码不生效,则试试

#修改加密规则 
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
#刷新权限 
FLUSH PRIVILEGES; 

 

参考https://blog.youkuaiyun.com/qq_43342301/article/details/91288891