开启MySQL远程访问权限

实现远程连接，将权限改成ALL PRIVILEGES

1.进入mysql安装bin目录，登录mysql数据库

2.远程连接授权操作

mysql> use mysql;
Database changed
mysql> grant all privileges  on *.* to root@'%' identified by "password";（此处password改成自己数据库密码）
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit;