sqlyog 无法连接

//修改配置文件
vi /etc/mysql/my.cnf
bind-address=0.0.0.0//允许全部IP
//重启mysql
sudo service mysql restart;重启mysql



//修改访问权限
//进入mysql

mysql> grant 你的权限 on *.* to '你的用户'@'IP地址' identified by '密码';
mysql>flush privileges;

//例如:

mysql>GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY '111111' WITH GRANT OPTION;