mysql_upgrade "FATAL ERROR: Upgrade failed"

NickolaiLeschov

Registered
Apr 11, 2014
2
0
1
cPanel Access Level
Root Administrator
When I ssh to the server and run mysql_upgrade, it returns:
Code:
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
Failed to ALTER DATABASE `#mysql50#.cache` UPGRADE DATA DIRECTORY NAME
Error: Incorrect database name '#mysql50#.cache'
Failed to ALTER DATABASE `#mysql50#.config` UPGRADE DATA DIRECTORY NAME
Error: Incorrect database name '#mysql50#.config'
Failed to ALTER DATABASE `#mysql50#.local` UPGRADE DATA DIRECTORY NAME
Error: Incorrect database name '#mysql50#.local'
Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/lib/mysql/mysql.sock' 
mysqlcheck: Got error: 1102: Incorrect database name '#mysql50#.cache' when selecting the database
FATAL ERROR: Upgrade failed
I tried to delete '#mysql50#.cache' - it throws:

Code:
#1102 - Incorrect database name '#mysql50#.cache'
What can I do?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
Hello :)

Does /var/lib/mysql/mysql50.cache exist as a directory on your system?

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
Those are not standard directories. Did you have a custom installation of MySQL at some point? Rather than removing those directories, I suggest moving them to another location and then checking to see if the same error message persists.

Thank you.