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

Access denied: funny user name returned

User, date Message
Written by kwdavids1
2 years ago
Category: Creating a connection
6 posts since Wed, 01 Feb 12
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.
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
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.
Written by kthanid
2 years ago
15 posts since Mon, 30 Jan 12
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).
Written by kwdavids1
2 years ago
6 posts since Wed, 01 Feb 12
My IP address changed. Now it works. Weird.
Written by kthanid
2 years ago
15 posts since Mon, 30 Jan 12
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.