mysql设置允许远程访问

针对所有ip

1、GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

针对1.2.3.4 ip

2、GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'1.2.3.4' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;

刷新

3、FLUSH PRIVILEGES;

若提示2003则删除绑定本地地址访问

4、

vi /etc/mysql/mysql.conf.d/mysqld.cnf

或者版本不同

vi /etc/mysql/my.cnf

注释掉bind-address = 127.0.0.1

若还不行则是防火墙的原因