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后可以远程连接了