How to Quickly Fix the PhpMyAdmin Continuously Redirecting Error?

How to Quickly Fix the PhpMyAdmin Continuously Redirecting Error?

When you try to access PhpMyAdmin, you may come across continuous redirect error. In such cases, you won’t be able to access the mysql database for a certain period of time. In most cases, the error is because of a corrupt ‘mysql’ database.

If you check the error log in cPanel, you will find the following information:

Code:
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)
The best way to fix this error is by upgrading your MySQL database. The error also hints that the current version is out of date. But before you upgrade or make any changes, its best to take a backup. For this use the following command:

Code:
mysqldump --all-databases | bzip2 -c > /home/databasebackup.sql.bz2
Once you’ve taken the backup, go ahead and execute the following command to make sure all database table checks and upgrades are of latest version:

Code:
mysql_upgrade
After it is complete, PhpMyAdmin will load again and the error will be fixed.

So that’s how you fix the continuously redirecting error in PhpMyAdmin. In case the problem persists, contact the hosting support team for assistance.
Author
kumkumsharma
Views
1,808
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from kumkumsharma

Top