安装mysql-server
sudo apt install mysql-server
编辑mysqd.conf
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
注释这一行
#bind-address = 127.0.0.1
重启服务
sudo systemctl restart mysql
客户端连接，密码不用输入按Enter
sudo mysql -u root -p
更改root密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH MYSQL_NATIVE_PASSWORD BY 'YOUR_PASSWORD';
允许root账号远程访问
update user set host='%' where user='root';
刷新权限
flush privileges;
重启服务
sudo systemctl restart mysql
