Entry

How do I fix this error: "MySQL Connection Failed: Access denied for user: 'mysql_user@mindgame.simctr.ida.org' (Using password: YES)"

May 8th, 2008 04:41
dave austin, Jan Huelsberg, Chris Kacerguis,

That means that the user on this machine with this password has no 
access. Remember, it is not only important to be the right user and 
have the right password. The authoriation tool of mysql (depending on 
how it is set up) might recognise you only from a certain host.
This information is stored in the 'user' table of the 'mysql' database.
If you have root access change the database to 'mysql' and do the select

select user, password, host from user.

There you should see from which host a specific user is allowed to 
connect.

Jan.

Also, if you use CPanel, or some similar control panel that your webhost
has provided you, in there the is usually a link that will allow you to
add the IP of your computer as an remote MySQL access point.  On CPanel
for example, the IP of your computer is usually listed at the top of the
main page ... make a note of it, click "Manage Remote MySQL Access" and
then add that IP.  IMPORTANT:  If you have a cable service you likely
have a changing IP address, controlled by your ISP so you will have to
change this value every time your ISP changes your IP.  You can get a
static IP from your ISP but they'll charge you $25/mo or so.