After the password modification, if you come across the below error in accessing PHPMyAdmin.
=-=-=-=-=-
Error from MySQL query: DBD::mysql::db do failed: Can't find any matching row in the user table at /usr/local/cpanel/Cpanel/Mysql.pm line 1195.
-==-=-=-=--
then, check for the entry,
=-=-=-=-
skip-name-resolve
=-=-=--=-
in /etc/my.cnf. Disable skip-name-resolve in my.cnf, restart MySQL will fix the issue.
Thats it
=-=-=-=-=-
Error from MySQL query: DBD::mysql::db do failed: Can't find any matching row in the user table at /usr/local/cpanel/Cpanel/Mysql.pm line 1195.
-==-=-=-=--
then, check for the entry,
=-=-=-=-
skip-name-resolve
=-=-=--=-
in /etc/my.cnf. Disable skip-name-resolve in my.cnf, restart MySQL will fix the issue.
Thats it