mysql upgrade err mysql.user table is damaged. Please run mysql_upgrade.

Submitted by lepton on Wed, 12/26/2018 - 13:28

Tags

Fatal error: mysql.user table is damaged. Please run mysql_upgrade.

add args --skip-grant-tables to /etc/conf.d/mysql MY_ARGS=""

run /etc/init.d/mysql restart 

run mysql_upgrade

remove args  --skip-grant-tables

/etc/init.d/mysql restart

Add new comment

About text formats

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.