Error 1045: Http Tunneling

[Mastu-Basta]

I tryed to use sqlyog via http, i put the SQLyogTunnel.php in root site directory.

Preferences:

Code:

HTTP Tunneling:
URL: http://mydomainwashere.com/SQLyogTunnel.php
—
MySQL:
MySQL Host Address: mydomainwashere.com
User Name: mysqlusername
Password: mysqlpass
Port: 3306

And when i press “Connect” or “Test Connection” i've got an error:

Quote:

Error No. 1045

Access denied for user 'mysqlusername'@'mydomainwashere.com' (using password YES)

But username and password are 100% correct. Why is it so?

—

I also tryed SSH Tunneling with preferences:

Code:

SSH Host: ssh://mydomainwashere.com SSH Port: 22
Username: mysqlusername Local Port: 3310
Password: mysqlpass

but it shows me

Quote:

SSH Error: Unable to open connection:

Host does not exist

But host is correct, i use it via putty.

[peterlaursen]

did you read http://webyog.com/faq/content/23/18/en/err…on-denied-.html

.. as well as other FAQs in same category and the 'getting started' paragraph in help file.

1) the http-issue

This is an authencation error, not a connection error

> try 'localhost' or '127.0.0.1' as 'MySQL host'. With HTTP tunnel you connect to MySQL from webserver/PHP on the remote host/network, not from your local machine. Probably this user does has not been allowed remote connections. (when specifying a global ip/alias it may not be 'resolved' to 'localhost')

2) the ssh-issue

this is a connection error!

–>try only 'mydomainwashere.com' not 'ssh://mydomainwashere.com'.

–>the user and password to specify on the 'SSH' tab is SSH/OS user – not MySQL user!

–>also here try use 'localhost' as host on the MySQL tab (note this was edited!)

[Author]

Posts