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.
精彩评论