进入mysql
grant all privileges on *.* to 'username'@'%' identified by 'password';
flush privileges;
退出mysql
修改mysql的配置文件 /etc/mysql/my.cnf
将bind-address = 127.0.0.1 这一行注释掉
重启mysql service mysql restart
进入mysql
grant all privileges on *.* to 'username'@'%' identified by 'password';
flush privileges;
退出mysql
修改mysql的配置文件 /etc/mysql/my.cnf
将bind-address = 127.0.0.1 这一行注释掉
重启mysql service mysql restart