How to fix Mysql table crashes

Whenever you enconter this:

  1. Please use mysql_upgrade to fix this error.

or using  mysql_upgrade -u root -p says:
  1. Looking for 'mysql' as: mysql
  2. Looking for 'mysqlcheck' as: mysqlcheck
  3. Error: Failed while fetching Server version! Could be due to unauthorized access.
  4. FATAL ERROR: Upgrade failed

you can try this:
  1. chown -R mysql /var/lib/mysql
  2. mysql_upgrade -u root -p





posted @ 2018-08-21 19:16  Jerry_Jin  阅读(404)  评论(0)    收藏  举报