HeidiSQL not connection to right Hostname

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.

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

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

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?

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.

Understood. Thanks for the help

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

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

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