一:修改mysql配置文件,允许远程连接
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address=127.0.0.1注释
二:登录mysql,运行命令
grant all privileges on . to ‘用户名’@’%’ identified by ‘密码’ with grant option;;
flush privileges;
三:重启mysql
service mysql restart
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
将bind-address=127.0.0.1注释
grant all privileges on . to ‘用户名’@’%’ identified by ‘密码’ with grant option;;
flush privileges;
service mysql restart