ubuntu20安装mysql8.0并配置远程连接

安装

sudo apt update

sudo apt install mysql-server

验证是否安装成功

systemctl status mysql

登录

首次登录遇到的问题

由于未找到初始密码，登录时提示

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES) or
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)

可以sudo mysql直接无密码进入

配置远程登录

1 查看user表中所有用户信息

use mysql;

select host, user, authentication_string, plugin from user;

2 更改root用户的host
update user set host='%' where user='root';
3 给予root 用户所有权限
GRANT ALL ON *.* TO 'root'@'%';
4 修改root用户密码及加密方式
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
5 刷新权限FLUSH PRIVILEGES;
6 最后sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf打开mysql配置文件注释掉bind-address=127.0.0.1
7 重启MySQL服务sudo systemctl restart mysql.service