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

Access denied: funny user name returned

kwdavids1 posted 3 years ago in Creating a connection
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 posted 3 years ago
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 posted 3 years ago
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).
kwdavids1 posted 3 years ago
My IP address changed. Now it works. Weird.
kthanid posted 3 years ago
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.