Could not establish connection!

Hi all,

I should manage a MySQL-Server and I got the username and the password of it. I also know the URL of the website which is using this MySQL-Server.

Now I have following Problem. When I try to connect to the Server using the website-URL (it's a subdomain ... so subdomain.domain.net) I get the following error-message:

Could not establish connection! Details:
SQL Error: Access denied for user
'xxxx'@'yyyy'
(using password: YES)

xxxx is the correct username.
but yyyy is not the correct hostname. instead of the website-URL there is standing my personal internet-provider-host?


If i try to connect to the "root-domain" (not the the subdomain of it) I get following error-message:

Could not establish connection! Details:
SQL Error: Can't connect to MySQL server on 'zzzz' (10051)

zzzz ist the correct "root-domain"


Could anyone help me? thanks

You are misinterpreting MySQL's error messages.

> but yyyy is not the correct hostname. instead of the
> website-URL there is standing my personal internet-
> provider-host?

Yes, that's very normal. MySQL displays the user host/ip in that message.

> Can't connect to MySQL server on 'zzzz'

You need to know the public name of your MySQL server. This is not the URL of your website.

My guess is you entered the correct hostname the first time, but entered a wrong password. You need a MySQL user/password combination, not some FTP account or so.

The username/password combination is form the MySQL-Server and NOT from the FTP.

Probably the problem is that you can connect only from "localhost"?

Is there a way to "bypass" this localhost restriction?

sry ... have to add:

the localhost-restriction is only a guess.

Yes, that's possible. You should contact the one who created your MySQL account. Tell him he shall allow access not only from "localhost" but from "%".

Yes, this is probably the problem.

There is no way to bypass that somehow (tunneling, SSH, etc.)?

---

Anyway I just want to say thanks for this great program (I tested it at another MySQL-Server from me).

Also thanks for the support :-)

Wishing you a nice evening

Oh, yes you can set up a SSH tunnel prior to connecting via HeidiSQL, look here for setup details.