distal-attribute
distal-attribute
distal-attribute
distal-attribute

HeidiSQL not connection to right Hostname

Kallar posted 9 months ago in Creating a connection

Hello,

I was trying to establish a connection to an external IP adress. But when I enter the Ip and try to connect following error shows up. As you can see the IP is a different one.

1 attachment(s):
  • error
kalvaro posted 9 months ago

That's your IP address, not the server's.

Kallar posted 9 months ago

And do you kniow why its not using the Ip I defined?

Kallar posted 9 months ago

Im probably blaming myself as a total scrub atm but I just realized could it be possible that the server denies my acces and im totally getting this error wrong?

ansgar posted 9 months ago

Yes, you got the error message wrong, but I can tell you you were not the first one getting it wrong.

The ip is yours, and the user name is combined with your current ip when you connect to the server. In MySQL you can have different privileges for a user root@192.168.222.252 and root@192.168.111.1 or whatever.

Kallar posted 9 months ago

Understood. Thanks for the help

Kallar posted 9 months ago

So this is the permissions table. I dont know what could be wrong there.

1 attachment(s):
  • error2
Kallar posted 9 months ago

Can eb marked solved. I was gieven a wrong a pssword.

kalvaro posted 9 months ago

You have a user called "root@%" that should apply ("%" is a wildcard) but "Using password: NO" means that you haven't typed any password.

Please login to leave a reply, or register at first.