开发者

Unable to connect to a local MYSQL server on wireles LAN

Ok, Here is the technical description.

My laptop's config:

Ip Adress:192.168.2.5

Mysqlserver 5.0 on port : 3306

Operating system: Ub开发者_运维技巧untu jaunty (9.04)

3306 is open for both incoming and outgoing.

My friend's laptop config:

Ip Adress:192.168.2.4

Mysqlserver 5.0 on port : 3306

Operating system: Windows XP pro

3306 is open for both incoming and outgoing.

Both are on a wireless LAN connected through a belkin router (192.168.2.1)

Both the MYSQL servers have been given the sufficient GRANT privileges. I am also able to connect from 192.168.2.4 to 192.168.2.5's MYSQL instance but the vice versa is not happening. I am getting an (100061) error. Tried Telnetting on 3306; again happening from 192.168.2.4 to 192.168.2.5 but not the vice versa. Am I doing something wrong?

Kindly suggest.


Is the mysql server of your friend accepting connections other then from localhost? Although i think this quest needs to be moved to serverfault.


Don't forget to use "flush privileges" after new grant statement; this has burnt me many times.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜