Access denied: funny user name returned

[expired user #6195]'s profile image [expired user #6195] posted 12 years ago in Creating a connection Permalink
I'm having a problem getting connected. The user name is "archko_archko" and I get the following message from HeidiSQL:
"SQL Error (1045): Access denied for user 'archko_archko'@'adsl-74-226-206-245.gsp.bellsouth.net' (using password: YES) */"

I don't know if the extra stuff after the user-id is normal or not. The password is right. I can connect to other hosts with HeidiSQL and I can connect to this host with other software on another machine.

Really stumped here.
ansgar's profile image ansgar posted 12 years ago Permalink
The right part of the username in the error message is the hostname from which it comes to connect. Very normal. MySQL needs to check this hostname, as there may be a user which is allowed to connect or not from this host.
kthanid's profile image kthanid posted 12 years ago Permalink
My guess is that you have created user archko_archko@localhost only, if connecting from another host you will either need to create a username specifically for that host or create an archko_archko@'%' user (this will allow you to connect as that user from any host).
[expired user #6195]'s profile image [expired user #6195] posted 12 years ago Permalink
My IP address changed. Now it works. Weird.
kthanid's profile image kthanid posted 12 years ago Permalink
Based on your hostname it looks like you're a DSL user (and assuming a non-static IP since you noted it changed). If you aren't paying to keep your IP static you should be aware that the IP assigned by your provider (AT&T, in this case, I believe) may change from time to time. They generally don't (because you hold a lease on that IP and generally maintain this while your DSL modem stays connected), but they can change.

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