开启mysql远程访问设置

1、mysql的配置文件，my.cnf文件中，注释掉bind_address=127.0.0.1

2、开启权限

       GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

       FLUSH PRIVILEGES;