Why I get access not allowed after changing password on PHPmyAdmin?

Standard

Sometimes when you change password for a account, it will say that mySQL pasword was changed (but it is either left the old one or added wrong one) so when you login to cPanel and start PhpMyAdmin you will get access not allowed error.

Workaround:
go to section MYSQL in whm and change passwords for users in that database once again. :)

How to Enable phpMyAdmin Designer Mode

Standard
  1. Create a control user named pma – replace pmapass below with a good password, then copy and paste the SQL into the SQL form field on phpMyAdmin