Mysql 连接报错 Table ‘performance_schema.session_variables‘ doesn‘t exist
一. 报错信息
2022-02-23 10:58:56,849 [4126] - ERROR [main:DBAccessorImpl@117] - Error while creating database accessor
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'performance_schema.session_variables' doesn't existat sun.reflect.GeneratedConstructorAccessor38.newInstance(Unknown Source)at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)at java.lang.reflect.Constructor.newInstance(Constructor.java:423)at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)at com.mysql.jdbc.Util.getInstance(Util.java:386)at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4187)at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4119)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570)at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2814)at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2763)at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1614)at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:4184)at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3587)at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2536)at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2306)二. 解决方式
2.1. (有效)使用root账号登录, 设置一个参数就可以了.
mysql -u xxx -p
mysql> set @@global.show_compatibility_56=ON;
2.2. (风险) 执行升级操作.
- 以管理员的身份运行:
mysql_upgrade -u root -p –force
- 重启mysql即可.
systemctl restart mysqld
------- 或者-------
service mysqld restart
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！