Mysql was crashed and was not starting. Though we ran innodb_force_recovery to up the mysql, there were many issues like core tables were crashed, phpmyadmin was not showing databases, 16 length user character issue and so on.

Also while checking mysql_upgrade_info file in the /var/lib/mysql directory, it was showing mysql5.6 though the server was having mariadb10.1 version.

mysql_upgrade saves the MySQL version number in a file named mysql_upgrade_info in the data directory. This is used to quickly check whether all tables have been checked for this release so that table-checking can be skipped

So this clearly shows that the mariadb upgrade was not completed properly.

Ran the following command to fix the issue.

# mysql_upgrade

and then restarted the mysql.

#/scripts/restartsrv_mysql

• cPanel
• Linux
• MySQL