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

HeidiSQL not connection to right Hostname

Kallar posted 1 month 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 1 month ago

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

Kallar posted 1 month ago

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

Kallar posted 1 month 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 1 month 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 1 month ago

Understood. Thanks for the help

Kallar posted 1 month ago

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

1 attachment(s):
  • error2
Kallar posted 1 month ago

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

kalvaro posted 1 month 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.