1. 打开/etc/mysql/mysql.conf.d/mysqld.cnf, 注掉 "bind-address = 127.0.0.1",
2. 重启mysql service "/etc/init.d/mysql restart"
3. 执行: mysql> GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'%' IDENTIFIED BY 'PASSWORD' WITH GRANT OPTION;
注意: 这里的USERNAME是你的数据库账户,PASSWORD是你的数据库密码
例如: mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
4. 执行: mysql> FLUSH PRIVILEGES;
5. 退出mysql命令行,执行: mysql -u root -h 192.168.0.1 -p