ubuntu22.04安装mysql8.0

0、刷新软件列表

sudo apt update

1、安装mysql

apt install mysql-server

2、查看运行状态

systemctl status mysql

3、进入mysql修改初始密码

#重置初始密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新密码';

#设置root可以远程访问并且修改密码

create user 'root'@'%' identified by 'yourpassword';

#赋予权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;

#刷新修改内容

FLUSH PRIVILEGES;

4、配置文件改为远程访问

#修改配置文件

sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

#注释掉绑定ip

#bind-address           = 127.0.0.1

5、修改密码加密规则

#修改用户密码加密规则

ALTER USER '用户名'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;

#修改用户密码

ALTER USER '用户名'@'%' IDENTIFIED WITH mysql_native_password BY '密码';

#刷新修改内容

FLUSH PRIVILEGES;

6、重启mysql后可以远程连接了