解决Navicat连接MySQL数据库报 1146 - Table ‘performance

    技术2022-07-29  82

    解决Navicat连接MySQL数据库报 1146 - Table 'performance_schema.session_variables' doesn't exist

    异常信息

    管理员身份运行命令提示符窗口,进入到MySQL的安装bin目录下,写入以下命令后回车,再输入MySQL密码,等待完成

    mysql_upgrade -u root -p --force

    命令提示符打印信息

    E:\develop\MySQL\MySQL_5.7\bin>mysql_upgrade -u root -p --force Enter password: **** Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db
    Processed: 0.010, SQL: 10