views:

174

answers:

2

Ok, Here is the technical description.
My laptop's config:
Ip Adress:192.168.2.5
Mysqlserver 5.0 on port : 3306
Operating system: Ubuntu 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.

A: 

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

Bloeper
Don't know actually. the 'bind-address' in the my.cnf is commented out, so i guess it should accept connections other than the localhost.
Arnab
And the host file of windows?
Bloeper
A: 

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

sneakerfish
"flush privileges" given. problem is still there.
Arnab
This is only required when you modify the grant tables manually, not when you use the GRANT statement.
Pascal Thivent