Ok, I've got a problem. I've got four people on a server, and want to setup phpMyAdmin so that each one can login and administrate their own databases. Here's what I've done so far:

1) I've setup phpMyAdmin to use advanced authentication. I can login fine using the username/password.

2) I've setup a username in MySQL just like the phpMyAdmin documentation says.

3) I've setup a database for the username in MySQL just like the phpMyAdmin documentation says.

Now, when I try logging in with the username/password I created in step 1, it gives me the following error:


Warning: MySQL Connection Failed: Access denied for user: 'radiomute@localhost' (Using password: YES) in lib.inc.php on line 255
Error


Anyone have advice?

This might help:

http://www.mysql.com/doc/A/c/Access_denied.html

Still can't figure this out. I tried accessing MySQL from the command line, but it still wouldn't work. Here's what I typed:


mysqladmin -u radiomute password


And here's what it said:


mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'radiomute@localhost' (Using password: NO)'


Now, like I said, I'm trying to get user 'radiomute' setup to work with database 'radiomute_db'. Anyone?

Justin,

When you created the users in MySQL did you use encryption for the passwords? Also do these users have their own websites and IP's or are they using sub-directories and the same IP??

Regards,
Brian P.

Thanks for the reply Brian, but I just figured it out. All I had to do was reload MySQL so it reset the user priviliges.

Forgot to FLUSH PRIVILEGES; I should have remembered that because I did that once or twice before myself. :)

Glad you got it working.

Regards,
Brian P.