How to Resolve PhpMyAdmin Not Loading Issues; Continues to reload and redirect (cPanel/WHM)

Symptoms

 

If PhpMyAdmin is failing to load or is continuously redirecting to itself, it may be possible that the "mysql" database is corrupted or needs to be upgraded.

 

Description 

 

It may be possible that the "mysql" database cannot be accessed while accessing PhpMyAdmin. If you check the cPanel error log (/usr/local/cpanel/logs/error_log) you may see this information being reported:

 

Cpanel::Exception::Database::Error/(XID 6pga43) The system received an error from 
the “MySQL” database “mysql”:
1805 (Column count of mysql.proc is wrong.
Expected 21, found 20. The table is probably corrupted)

 

Workaround

 

To resolve this, you will need to perform a mysql_upgrade. It is recommended to first take a backup of your databases before doing this. If you do not have any database backups, and are not sure how to take a backup, you can use the command below:

 

mysqldump --all-databases | bzip2 -c > /home/databasebackup.sql.bz2

 

Once you have taken a backup of your databases, you can use the command below to ensure all database tables are checked and upgraded for the latest version

 

mysql_upgrade

 

Once this is complete, PhpMyAdmin should be able to load once again.

Was this answer helpful?

Related Articles

How to Change the Default Nameservers in the WHM Root

You can change the default nameservers in your WHM Root Account. Note: Root access is required....

How to Change the Password of the WHM Root Account in WHM

You can change the root user account password from WHM. 1. Log in to your WHM Root Account. 2....

How to Disable Features That Another Feature List Cannot Override in WHM Root

Root Access is Required. You cannot access it through the WHM Reseller Account. Do you want to...

How to Change the Login Theme of cPanel/WHM/Webmail From WHM Root

You can change the default login theme for users, which displays when they log in to cPanel, WHM,...

How to Check or Change Server Time via WHM Root

If you want to change the server time, you can easily do it from WHM Host Manager. 1. Log in to...