Access to phpMyAdmin fails with error Access Denied or Cannot connect: invalid settings.

Symptoms

Access to phpMyAdmin fails with error Access Denied or:

    Cannot connect: invalid settings

Cause

1. Admin credentials for Mysql server are not correct.
2. URL Rewrite rule prevents PHPMyAdmin.

Resolution

1. Make sure that you can connect to Mysql using command line utility:
   

   "%plesk_dir%mysql\\bin\\mysql" -uadmin -p"*******" -P3306 mysql

where * is the password for client Mysql Server.

1. Try to reset password in Plesk Control panel > Tools and Settings > Database Servers > Mysql > Settings .

2. Make sure that there is no custom URL Rewrite rules in IIS > server hostname > URL Rewrite

   • Deactivate all rules.

   • Recycle PleskControlPanel application pool in IIS > server hostname > Application Pools

   • Check PhpMyAdmin again.