mysql版本5.7
1、权限问题
use mysql;
select * from USER;
create user 'userName'@'%' identified by 'pwd'; -- userName为用户名, %代表任何主机, pwd为用户密码
grant all privileges on *.* to 'userName'@'%' identified by 'pwd';
flush privileges;
2、防火墙问题
关闭防火墙再试下
mysql版本5.7
1、权限问题
use mysql;
select * from USER;
create user 'userName'@'%' identified by 'pwd'; -- userName为用户名, %代表任何主机, pwd为用户密码
grant all privileges on *.* to 'userName'@'%' identified by 'pwd';
flush privileges;
2、防火墙问题
关闭防火墙再试下