forums › forums › SQLyog › Using SQLyog › Error 1130
- This topic is empty.
-
AuthorPosts
-
-
September 9, 2003 at 9:11 pm #8160janNowak07Member
Have just downloaded and installed a trial version of v3.52. Everything seems to work fine with the MySQL installed locally. When I try to connect to my remote server, I get the following message: “Error 1130: Host xxxxxxxx is not allowed to connect to this MySQL Server”. My machine runs Windows XP Pro and the remote server I'm trying to connect to is on Linux. I am on a local area network. Thanks in advance for your assistance.
-
September 11, 2003 at 4:15 am #14876RiteshMember
Are you behind a firewall?
-
September 12, 2003 at 10:17 pm #14877janNowak07Member
Yes but I guess the filter was set up properly. Or I'm wrong. Anyway, can do with whatever help I can get. Many thanks.
-
September 13, 2003 at 3:57 am #14878RiteshMember
You cannont use SQLyog behind a firewall. Try SSH tunneling.
-
September 19, 2003 at 9:30 pm #14879lantzMemberRitesh wrote on Sep 13 2003, 03:57 AM:You cannont use SQLyog behind a firewall. Try SSH tunneling.
What do you mean? I'm having the same problem and am VERY new to database servers… I'm trying to get away from my Microsoft Access Bad Habits! 😉
Thanks,
Lantz
-
September 20, 2003 at 4:31 am #14880RiteshMember
You can try http://www.codemastershawn.com/library/tut…/ssh.tunnel.php 🙂
HTH
-
October 15, 2003 at 7:34 pm #14881cadillac1960Member
I too am having the error 1130 show up when I try and log in.
I have modified the hosts file in the etc folder on my server, but still can not get SQLyog to connect.
The error I get is:
==========
Error 1130
Host 'adsl-216-1-3-88-179.dsl.snfc21.pacbell.net' is not allowed to connect to this MySQL server
==========
I have tried modifying the hosts file with this exact address, as well as other logical choices, but am still being denied access.
Any help greatly appreciated.
-
October 16, 2003 at 4:05 am #14882RiteshMember
Provide '%' for HOST column.
-
November 11, 2003 at 4:04 pm #14883urbsomMember
I too am recieving the Error 1130. I am trying to connect to a local linux box, 192.168.1.230, from a winxp machine, 192.168.1.169, with SQLyog. I have tried putting the ip 192.168.1.169 in the host column along with % and evildojo (the hostname of the winxp machine which is in my linux box's host file). Strange thing is that I can connect to the linux box with SQLyog from a win2k machine, ip 192.168.1.200, that resides inside my network with no problems. Note: Since all machines are on my my local network there is no firewall between the windows clients and the linux box.
Is this a winxp issue or am I just missing something here? Any help is greatly appreciated.
Thanks,
Jerome Urban ([email protected])
-
November 12, 2003 at 6:12 am #14884RiteshMember
There is no difference between XP and 2k.
Are you sure you have given the correct permission tothe XP host as you have given to the 2k host?
-
November 14, 2003 at 2:50 pm #14885urbsomMember
Yes. I tried all sorts of things to try and give the xp host permissions. I attempted to use its IP, then its hostname, then just the wildcard %.
-
-
AuthorPosts
- You must be logged in to reply to this topic.