windows mysql数据库远程连接

使用root远程连接mysql

1. grant 权限 on 数据库名.表名 to 用户@登录主机 identified by "用户密码";

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

mysql> select host,user,password from user;+-----------+------+-------------------------------------------+| host      | user | password                                  |+-----------+------+-------------------------------------------+| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 || 127.0.0.1 | root | *AB80F1BAA821C359336F883FA5C387256681A7DF || ::1       | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 || %         | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |+-----------+------+-------------------------------------------+4 rows in set (0.00 sec)

2. net stop mysql57

3. net start mysql57

4. 关闭windows防火墙

5. 远程连接

如果没有关闭防火墙，可能出现如下情况：