mysql开启远程连接的权限_开启MySQL远程访问权限 允许远程连接

1、先定位到mysql安装目录bin文件夹

2、cmd打开doc，cd  ..\..\..\bin

3、mysql -u root -p 数据库名

然后进行下述操作

mysql> use mysql(数据库名);

Database changed

mysql> GRANT ALL PRIVILEGES ON *.* TO '用户名'@'允许连接ip(所有为%)' IDENTIFIED BY '密码' WITH GRANT OPTION;flush privileges;

Query OK, 0 rows affected (0.00 sec)

mysql> select host,user,password from user;

+--------------+------+-------------------------------------------+

| host         | user | password                                  |

+--------------+------+-------------------------------------------+

| localhost    | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |

| 192.168.1.1 | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |

| %            | root | *A731AEBFB621E354CD41BAF207D884A609E81F5E |

+--------------+------+-------------------------------------------+

3 rows in set (0.00 sec)