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:
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:
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:
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.
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)
Code:
mysqldump --all-databases | bzip2 -c > /home/databasebackup.sql.bz2
Code:
mysql_upgradeSo that’s how you fix the continuously redirecting error in PhpMyAdmin. In case the problem persists, contact the hosting support team for assistance.
