How To Access Mysql (windows Platform) From A Client Pc

[Bill Nguyen]

I have mySQL 5.0 installed in a Wins 200x server. It's working fine

Using SQLyog Enterprise 8.12, I can access mySQL databases locally using host localhost and rơt password

However, when I tried to access from my own PC using FQN of the Windows server running mySQL (webportal.jacoil.com), I got the following error:

---

SQLyog Enterprise – MySQL GUI

---

Error No. 1130

Host 'it-99.jacooil.com' is not allowed to connect to this MySQL server

---

OK

---

What setup do I need to have in order to connect to mySQL from a PC on the network?

Thanks

Bill

[peterlaursen]

We have this FAQ:

http://www.webyog.com/faq/content/23/36/en…t-connect-.html

You should not that this is far the most popular (or 'infamous') FAQ we have. It tells that lots of people face this problem and the solution is not always easy to find. But try read it and see if there is something that will help. If not you may let us have a look at the host file from the server (you can create a ticket for privacy). Also tell what kind of server this is. If you do not have administrative rights to the server so that you cannot get this information, I am afraid that only the server admin will be able to solve it.

I also hope you understand that this is not an issue with SQLyog. Any client would face the same problem. The large number of 'hits' to this FAQ are not SQLyog users primarily. It is people searching this error in Google.

[Bill Nguyen]

peterlaursen wrote on Aug 7 2009, 08:53 PM:

We have this FAQ:

http://www.webyog.com/faq/content/23/36/en…t-connect-.html

Thanks Peter!

I have admin rights on this Windows 2008 Enterprise server (housing Sharepoint MOSS 2007).

I was able to connect using HTTP-tunneling, but still wonder about the performance of HTTP-tunneling vs direct connect.

Bill

[peterlaursen]

I think you could try the option to create a 'root clone' like

Code:

GRANT ALL PRIVILEGES TO 'rootclone'@'%' on *.* WITH GRANT OPTION;

(or specify the host from where you connect instead of '%')

.. and next try to connect as 'rootclone'. But this is a Windows server so maybe it is quite another issue.

I have no exact metrics on HTTP-tunnelling performance compared with other options. I think it depends on PHP configuration, how busy the webserver is, webserver configuration etc.

[Author]

Posts