MYSQL5.7 开启远程访问

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