Ubuntu with mySQL error connecting from XP

yovkoi · 12-11-2010, 09:04 AM

Hi, installed mySQL-server on the Ubuntu and configured it(i've made this lots of times). After that I installed mySQL-Admin and connected successfuly to the server. Tried some queries and worked fine. So, then I opened tcp 3306 for incoming and outgoing from anywhare. Went to my XP station and install mysql odbc driver, allowed tcp 3306 and tried to connect but I got an error 10061. So I decided to telnet my server with 3306 port and I got "connection failed". Any ideas why this is happening?

smoker · 12-11-2010, 09:29 AM

Is the user you are connecting as from XP, allowed to connect to mysql from any host ? Check the privileges. The default allowed connection is localhost. You would need to modify that users privileges to allow connections from the XP machine.

yovkoi · 12-11-2010, 09:42 AM

Quote:

Originally Posted by smoker

Is the user you are connecting as from XP, allowed to connect to mysql from any host ? Check the privileges. The default allowed connection is localhost. You would need to modify that users privileges to allow connections from the XP machine.

Yes, I've done that. The problem is that I cannot even telnet 3306 from the localhost.