If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Just installed mysql, it won't let me login.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-05-07, 23:25
cesarvega cesarvega is offline
Registered User
 
Join Date: Apr 2004
Posts: 9
Just installed mysql, it won't let me login.

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,
Reply With Quote
  #2 (permalink)  
Old 02-06-07, 04:41
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,259
what permissions have your GRANTED the various users?

I find it easier to set permissions using MySQL Admion than using the older GRANT statement
__________________
I'd rather be riding my Versys or my Tiger 800 let alone the Norton
Reply With Quote
  #3 (permalink)  
Old 02-06-07, 10:46
cesarvega cesarvega is offline
Registered User
 
Join Date: Apr 2004
Posts: 9
Thanks.
I've just found a combination of both mysql permissions problem and a problem with my hosting provider to make it worse.

Anyway, I found it very hard to grasp than the host is involved directly in the permissions.
I mean, since I was denied access since the very moment of the telnet, before entering any credentials, it made me thought it was a network problem, not permissions. Of course I know I had to rtfm, but seemed a simple task.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On