我想从外部服务器连接公司局域网中的某mysql
局域网中的这台mysql
mysql> use mysql
Database changed
mysql> select Host,User from user;
+-----------+------+
| Host | User |
+-----------+------+
| % | root |
| 127.0.0.1 | root |
| localhost | |
+-----------+------+
3 rows in set (0.00 sec)
局域网中的这台mysql
mysql> use mysql
Database changed
mysql> select Host,User from user;
+-----------+------+
| Host | User |
+-----------+------+
| % | root |
| 127.0.0.1 | root |
| localhost | |
+-----------+------+
3 rows in set (0.00 sec)
mysql命令行:mysql -h219.*.*.* -uroot -p
linux下错误:ERROR 2003 (HY000): Can't connect to MySQL server on '219.*.*.*' (110)
GRANT ALL PRIVILEGES ON *.* TO 'mysqluser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 试试,如果其它方面没问题,就肯定是这个的问题了,我确定。
个人ip地址 协定 排程
192.168.0.103 TCP 3306/ 3306 任何时间
按楼主描述,个人感觉应该不是固定IP吧?
mysql要固定IP才连得上啊..