can't login to phpmyadmin

candyman123 · 05-27-2006, 03:45 PM

I haven't used phpmyadmin in a while, and just recently upgraded.

I can still log into sql:

mysql -u root -p

I type in the password and everything is good. When I go to:

http://localhost/phpmyadmin

I get a prompt for a user name and password. I use the same username and password and it doesn't let me in.

Forgive me if I'm completely lost. How do I login to phpmyadmin?

comprookie2000 · 05-27-2006, 04:14 PM

Check the config file for phpmyadmin. It should be under your document root.
Something like
/var/www/localhost/phpmyadmin/config.inc

sdexp · 05-27-2006, 08:18 PM

You need to have a control user who can access the table User in database mysql.

You need to grant permissions to a new member you make under root to do this. A possible user is made under root with

Code:

mysql -u root -p

such as

Code:

GRANT ALL ON mysql.User TO phpmyadmin@localhost
IDENTIFIED BY 'phpmyadmin'

Please choose a better password.

Then, update the config.inc.php file as mentioned in the last post.

Now you can login.