数据库MySQL在MySQL5.7.6版本之后,导入的文件只能在secure_file_priv 指定的文件夹下。
执行 mysql> show variables like ‘%secure%’;
ERROR 1682 (HY000): Native table ‘performance_schema’.‘session_variables’ has the wrong structure
原因: 原因在于升级的时候,这张表没升成功。
删除threads表,重建theads表,重启MySql,问题解决。
mysql> drop table threads;
mysql> CREATE TABLE threads
(
-> THREAD_ID
bigint(20) unsigned NOT NULL,
-> NAME
varchar(128) NOT NULL,
-> TYPE
varchar(10) NOT NULL,
-> PROCESSLIST_ID
bigint(20) unsigned DEFAULT NULL,
-> PROCESSLIST_USER
varchar(16) DEFAULT NULL,
-> PROCESSLIST_HOST
varchar(60) DEFAULT NULL,
-> PROCESSLIST_DB
varchar(64) DEFAULT NULL,
-> PROCESSLIST_COMMAND
varchar(16) DEFAULT NULL,
-> PROCESSLIST_TIME
bigint(20) DEFAULT NULL,
-> PROCESSLIST_STATE
varchar(64) DEFAULT NULL,
-> PROCESSLIST_INFO
longtext,
-> PARENT_THREAD_ID
bigint(20) unsigned DEFAULT NULL,
-> ROLE
varchar(64) DEFAULT NULL,
-> INSTRUMENTED
enum(‘YES’,‘NO’) NOT NULL
-> ) ENGINE=PERFORMANCE_SCHEMA DEFAULT CHARSET=utf8;
问题解答1:ERROR 1682 (HY000): Native table 'performance_schema'.'session_variables' has the wrong struct
最新推荐文章于 2024-03-18 10:19:53 发布