局域网mysql数据库访问

1、调出mysql 命令界面

输入命令：

mysql> use mysql
Database changed
mysql> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| 192.168.3.3 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
|192.168.3.7 | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+-----------+------+-------------------------------------------+
3 rows in set (0.00 sec)

2、实现远程连接（授权法）

将host字段的值修改为%表示在任何客户端机器上能以root用户登录到mysql服务器上。

update user set host='%' where  host='192.168.3.7';

mysql> update user set host='%' where host='192.168.3.7';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0


mysql> select host,user,password from user;
+-----------+------+-------------------------------------------+
| host      | user | password                                  |
+-----------+------+-------------------------------------------+
| localhost | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| 192.168.3.3 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| %         | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+-----------+------+-------------------------------------------+
3 rows in set (0.00 sec)
3、直接在user 表中直接加入特定的用户；

mysql> grant all privileges on *.* to  root@'192.168.1.1' identified by "root";
Query OK, 0 rows affected (0.00 sec)

刷新后更新的数据生效
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)


mysql> select host,user,password from user;
+-------------+------+-------------------------------------------+
| host        | user | password                                  |
+-------------+------+-------------------------------------------+
| localhost   | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| 192.168.3.3   | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| %           | root | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
| 192.168.1.1 | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+-------------+------+-------------------------------------------+
4 rows in set (0.00 sec)