[RESOLVED] Adding users to phpMyAdmin

[phence]

Hi all,

I am over here pulling my hair out trying to figure out how i can possibly add a user to phpMyAdmin.

I have my own dedicated server so i have all the permissions.
I have recently upgraded to phpMyAdmin 2.6.2-pl1.

Now, i have created a new MySQL user on my server and now i want to give that user the ability to user phpMyAdmin.

I have already created a link from the central location of phpMyAdmin to the users directory on the server. So now the user can go to www.theirdomain.com/phpMyAdmin, and they get prompted with a HTTP login box.

NOW!! ofcouse, i try to login with the username and password that i set their mysql account up with and I get access denied.

How on earth do I add a user to phpMyAdmin? I looked where I installed phpMyAdmin and I cannot find a .htaccess to edit. and in their documentation they warn about using a .htaccess for authentication other than what is confugured in the config file.

What on earth do I have to do to add a user to phpMyAdmin?

Thank-you,
phence

[Pandacoder]

I had a similar issue a long time ago so I can't give a solution exactly, just some pointers to what you should che out. When you create a user, as far as I remember you need to also give permissions to this user as to which db and tables they get access to.

In phpMyAdmin, if you look at the Mysql db, you see there iare tables for users, db and tables_priv. You should make sure that the user has priveleges in the db and tables_priv tables. Ane when you are done I seem to remember you need to 'Flush' the tables for the new user to get all the priveleges working.

Sorry can't be more specific...

Pandacoder

[phence]

Thanks for the advice!

I found my solution here! http://www.phpbuilder.com/board/showthread.php?t=10306516

[LoganK]

Please mark this resolved!