☰

無法從 mysql.proc 載入

tag-icon • tag-icon mysql
無法從 mysql.proc 載入

我無法轉儲 MySQL 資料庫，但錯誤訊息如下：

Cannot load from mysql.proc. The table is probably corrupted

另外 mysql_upgrade 似乎不起作用：

# mysql_upgrade
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
FATAL ERROR: Upgrade failed

這意味著什麼 ？

答案1

嘗試以 root 身分登入 MySQL，然後重試mysql_upgrade

相似之處 Parallels Plesk 面板:

# mysql_upgrade -uadmin -p`cat /etc/psa/.psa.shadow`

預設方法:

# mysql_upgrade -u <username> -p <password>

相關內容