服务器如何开启远程访问mysql?
1. 创建远程访问账号
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
2. 修改/etc/mysql/my.cnf , 注释:#bind-address = 127.0.0.1
3. 重启mysql:service mysql restart ,或者使用以下命令:
FLUSH PRIVILEGES;
5. 服务器对外开放3306端口