InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch)

By luxian, 5 December, 2016

Recently I had to investigate some Drupal website crashing. While debugging I noticed a lot of mysql crashes and MySQL log was full of errors like this:

InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch)

After some searching I managed to fix it by running mysql_upgrade command:

mysql_upgrade -u root -p <mysql_root_pass>

I added -p because my root user has a password, you can try without it first.

Source.

Tags

Comments3

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.

Tristan (not verified)

6 years 6 months ago

Thanks so much, I tries many searches to find my problem, I ended here googling the full error (what you quoted", everything if now fine.
Thank you so much =)

Rich (not verified)

6 years 6 months ago

Thanks for sharing, this solved a problem for me, too.

Marco (not verified)

6 years 4 months ago

Thank you,
i had the same problem and your solution worked!