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

[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