I've just installed MySQL (5.0.27) on a windows server, for the first time in a remote server.
Using Terminal Services I can open the MySQL Administrator, create my database, etc. The MySQL Browser Tool, also works fine connecting to "localhost".
Now, I want to connect from my PC and it tells me:
Quote:
Could not connect to the specified instance.
MySQL Error number 1130
Host "public ip here" is not allowed to connect to this MySQL Server.
|
(I tried the 3 public IPs on this server, with same luck)
The ping button responded fine.
Now, I tried to telnet "the server ip" 3306 from my PC and I get the same message. If I go to the server through terminal services and does the same, I get the same message, too !
But, if I "telnet localhost 3306" within the remote server, then yes, it works, fine. So the instance is up and running I can see the tables.
It seems it just could not bind to any of the IPs on this server.
I think this might be an obvious issue, but I already searched for an option that allows MySQL to listen through TCP/IP, but seems it is open by default.
Where do I start with ?
Thanks in advance,