search

Home  >  Q&A  >  body text

session_variables table does not exist in performance_schema

After upgrading MySQL to version 5.7.8-rc and logging into the server, I encountered the following error:

表'performance_schema.session_variables'不存在

I can't find any solution. can you help?

P粉504920992P粉504920992437 days ago1260

reply all(2)I'll reply

  • P粉294954447

    P粉2949544472023-09-23 12:36:21

    After running the command suggested by @robregonm, I was able to successfully log into the mysql server:

    mysql_upgrade -u root -p --force

    Need to restart the MySQL server.

    reply
    1
  • P粉788571316

    P粉7885713162023-09-23 09:02:12

    mysql_upgrade also works for me:

    # mysql_upgrade -u root -p --force
    # systemctl restart mysqld

    good luck, MSz.

    reply
    1
  • Cancelreply