acces phpmyadmin asking username and password

The easiest answer is to clear your cache, close all browsers and then give it another try from the start. Also be sure you're not logging into a normal cPanel account as root or reseller.

 

If that doesn't work, then it's likely your account's MySQL password has gotten out of sync with your cPanel account password. Under normal circumstances those passwords are the same, however, the way that phpMyAdmin was loaded in previous versions (cPanel versions before 11.28) it would ensure that the password was synced before loading the application. In 11.28 we removed that auto-syncing functionality and added the login form. In this way, if you're MySQL password is different for a reason, we don't overwrite it, and you can still log into phpMyAdmin.

If you can put your cPanel username and password into the phpMyAdmin login form and successfully authenticate, then the problem is most certainly just cache related, as InfoPro suggests. This will be the case most of the time.

Regards,
-DavidN

Reference Notes
- CHANGLOG: Case 43447
- Release Notes: Changed to phpMyAdmin Authentication

 

If the cPanel user password and MySQL password are not the same, you can try resetting the account password using Main >> Account Functions >> Password Modification. This function will attempt to reset the cPanel user password for the system and MySQL. This should result in the system password and MySQL password again being in sync, preventing the phpMyAdmin log-in page.

If you are able to log into phpMyAdmin using the existing cPanel username and password, then clearing the browser cache should help. If it does not, please submit a ticket so that we may investigate the problem directly on your server and offer more specific advice.

 

This used to be a manual operation performed by a system admin. Typically this was/is for users who use their main cPanel account for the MySQL access credentials when configuring something like wordpress. Making the passwords distinct prevented an exploit in something like wordpress from giving the perp access to the cPanel account.

 

Hello ckh,

Could you try running the following script to see the results:

Code:

/usr/local/cpanel/bin/updatephpmyadmin --force

If this does not work, please see if you can even get into MySQL command line:

Code:

mysql
mysqladmin proc

If both return an error about root@localhost, please post the error message. This would indicate an issue with MySQL functioning properly for the root user to connect with the /root/.my.cnf password set (please do not change the root password manually in the /root/.my.cnf file at any time, since this does not change it in MySQL itself).

Thanks!