Error 1130

[Frisbee]

I´m a MySQL beginner and am able to connect to my database through a Telnet program (like PuTTy), but when I try to connect to the database-server with SQLyog, I got the following message:

1130 – Host ´reth530-aXXX.otenet.gr`(XXX = 3 digits) is not allowed to connect to this MySQL server.

After mentioning this to the host, they told me that they had to open the server for my IP-number, to protect against unautorized access. so, I gave them my IP & received later that day an e-mail that all must be okay now, but unfortunately I still get the same error screen <_< I´ve noticed that the 3 digits (the XXX) change when I start another dial-up connection and presume that my database server is reading the IP from my internet-provider and NOT my IP. My host supports for security reasons only SSH2 -3DES encryption; can this be the problem? Or is the problem with the IP´s something I have to discuss with my provider? Any help is welcome…………

[CalEvans]

If you are on dialup then yes, your IP address changes every time you connect. They need to grant access to your database to yourlogin@%.

The other thing you can do is use ssh to tunnel the port.

1: Setup putty to tunnel 3306

2: Connect to your host with putty (ssh)

3: open sqlyog

4: connect to localhost with sqlyog

I do it for one of my databases and it works great. (I use SecureSSH from http://www.vandyke.com though)

HTH,

=C=

[Author]

Posts