If you have Upgraded or Downgraded MySQL/MariaDB Version, you may fall into phpMyAdmin Access Denied Error. If you are trying to redirect to phpMyAdmin from cPanel Account and you are prompted for Username and Password and you see “mysqli_connect(): (28000/1045): Access denied for user ‘cpses_deiskeisdj4g’@’localhost’ (using password: YES)”. This Probably means that the root user password is changed.
Ask your hosting provider to change root password of database for you. Or if you are the owner of your WHM Account, then Login to WHM Account and Search for “MYSQL Root Password” and Reset It.
Try Clicking on phpMyAdmin again after password reset and this time it should work. If not, then login to your Linux Server and execute below command.
# vim /usr/local/cpanel/base/3rdparty/phpMyAdmin/config.inc.php
go to line number 62 and uncomment it,
# $cfg[‘Servers’][$i][‘controlpass’] = ‘pmapass’;
Try Opening phpMyAdmin now and see if It works.
If you Like Our Content here at Devopsage, then please support us by sharing this post.
Also, Please comment on the post with your views and let us know if any changes need to be done.