Re: MySQL Error number 2003???

[Sergio Ortiz]

Was difficult but finally find a solution for me, i had the same problem specified in the first message and we do the next steps
First, i was unable to find de the server, send me the message that instance not found, but everything was ok in the server, so a went to :\Windows\Systme32\Drivers\etc\ there i edit the file 'hosts' with notepad and add the server at the last line, something like this

'server ip' 'server-name'

then made the change in my.cnf file, i comment the line bind-address = 127.0.0.1:

a new issue was presented, access denied was the new error message, so looking around, we find out this, in the mysql administrator, using root session, in the screen users administration, where the users are listed, select the user that wants to logon and then right clic, and clic on add new host, just add the host name from where the user is trying to loggin or simply create a '%' host for enable user to logon from any computer to the server instance, that resolve my problem, hope this help someone.

Panda.



Edited 1 time(s). Last edit at 09/27/2007 03:05PM by Sergio Ortiz.