MySql怎样允许主机被远程访问

在MySQL中，客户端想要远程访问服务器，必须在服务器端进行设置，允许被某台机器远程访问。

如：这里客户端192.168.9.141的机器想要远程访问192.168.6.51的服务器。

--在服务器端配置：

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

--允许192.168.9.141这台机器以dandan/dandan进行连接该服务器。

mysql> select host,user from mysql.user;
+---------------+--------+
| host          | user   |
+---------------+--------+
| 127.0.0.1     | root   |
| 192.168.9.141 | dandan |
| ::1           | root   |
| localhost     |        |
| localhost     | root   |

可以看到在mysql.user里自动生成了一条user为dandan,host为192.168.9.141的记录。

--在客户端进行连接：

C:\Users\dandan>mysql -u dandan -p -h 192.168.6.51
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 20
Server version: 5.6.20-r5436 Source distribution


Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.


mysql>