Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

HeidiSQL not connection to right Hostname

Kallar's profile image Kallar posted 3 years ago in Creating a connection Permalink

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's profile image kalvaro posted 3 years ago Permalink

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

Kallar's profile image Kallar posted 3 years ago Permalink

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

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
Kallar's profile image Kallar posted 3 years ago Permalink

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's profile image ansgar posted 3 years ago Permalink

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's profile image Kallar posted 3 years ago Permalink

Understood. Thanks for the help

Kallar's profile image Kallar posted 3 years ago Permalink

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

1 attachment(s):
  • error2
Kallar's profile image Kallar posted 3 years ago Permalink

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

kalvaro's profile image kalvaro posted 3 years ago Permalink

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.