Configure Http Connection

[Bill Nguyen]

It's all my fault!

My PC crashed, I had to reinstall everything including SQLyog. I updated sqlyogtunnel.php to the /www (or /public_html)

Now that I don't remember how to configure HTTP mode to connect my databases on my account with BlueHost.

I have a primary account/password to access bluehost Cpanel and mySQL databases. I also have couple accountID for the databases I created for my domain.

I always got the error 1045 access denied for user [email protected] (password YES).

Please tell me what to put in the SQL tab and the HTTP tab in connection setup dialog box

Thanks

Bill

[peterlaursen]

Please first read the 'getting started' paragraph of the program help file about HTTP-tunnelling.

What can be a little tricky is this:

http://webyog.com/faq/content/16/66/en/wha…-at-an-isp.html

It is impossible for us to know what hostname to use for connecting from the tunneller to the MySQL server with specific hosting (if it is not 'localhost').

[Bill Nguyen]

peterlaursen wrote on Jun 26 2009, 06:30 PM:

It is impossible for us to know what hostname to use for connecting from the tunneller to the MySQL server with specific hosting (if it is not 'localhost').

Dear Peter;

The mysql server host name is vanhocvietnam.org. That's what I entered in both SQL & HTTP tabs. (http://vanhocvietnam.org/SQLyogTunnel.php)

The problem is that what to put in the field “UserName” and “Password” in both SQL tab and Advanced – Use Credentials portion of HTTP tab.

I enter the primary userID and password. This is the account I can access CPanal, mySQL control panel, and PHPmyAdmin.

Still got access denied for the account in question.

Hope this help clarify the issue.

thanks

Bill

[peterlaursen]

“access denied” is a MySQL authentication error. That means that what you do in HTTP tab works! It is the MySQL user details that are wrong. What your MySQL user name and password is I cannot possible tell. Does not Cpanel tell you? Or can't you see in phpMyAdmin configuration? Don't you have some other webapplication (blog system, forums system, guestbook etc) where you can read it in the configuration file. (most such app's have a config.php file or similar where it is human readable).

You found that information once before and you should be able to find it again! Anyway the phpMyAdmin configuration file has the details – but on a shared server you may not have access to it.

[Bill Nguyen]

peterlaursen wrote on Jun 26 2009, 08:55 PM:

It is the MySQL user details that are wrong. What your MySQL user name and password is I cannot possible tell.

Peter;

You are correct, again!

I put my domain name in the box instead of “localhost” and that has caused all the troubles! I tried localhost (default, supplied any userid & password I created in mySQL and it worked!

Íll save the info, in case my PC crashes again!

Thanks

Bill

[peterlaursen]

Simply backup the sqlyog.ini file. All connections details are stored here.

[Author]

Posts