先用终端连接数据库
给用户授权
mysql> GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
mysql> flush privileges;
cd /etc/mysql/mysql.conf.d/
修改mysqld.cnf文件
vim mysqld.cnf
sql2.png
bind-address = 0.0.0.0
sql1.png
把bind-address =127.0.0.1 修改成 =bind-address =0.0.0.0
