1.安装mysql
sudo apt install mysql-server
2.配置远程连接
sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf
# 注释掉
bind-address = 127.0.0.1
3.修改root密码
sudo mysqladmin -u root -p password
# 我安装的这个版本安装时没有设置root密码的提示,这个随便输
Enter password:
# 填你的密码
New password:
Confirm new password:
4.开启root远程登录权限
sudo mysql
use mysql;
grant all privileges on mysql.user to 'root'@'%' identified by 'root' with grant option;
flush privileges;
5.重启mysql服务
sudo service mysql stop
sudo service mysql start
网友评论