mysql 5.5升级5.6报错：ERROR 1193 (HY000) at line 84: Unknown system variable 'have_csv'_unknown prepared statement handler (stmt) given to-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_39459385/article/details/84584267

在尝试将MySQL从5.5升级到5.6时遇到了ERROR 1193等相关错误，问题源于软链接指向了错误的MySQL版本。通过检查.bash_profile，发现MySQL命令指向了5.5版本，更新配置并正确设置环境变量后，使用mysql_upgrade成功完成了升级。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先登陆数据库没有问题呀，但是有报错，

文本显示：

ERROR 1193 (HY000) at line 84: Unknown system variable 'have_csv'
ERROR 1064 (42000) at line 86: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 (HY000) at line 87: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 88: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
ERROR 1193 (HY000) at line 92: Unknown system variable 'have_csv'
ERROR 1064 (42000) at line 94: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NULL' at line 1
ERROR 1243 (HY000) at line 95: Unknown prepared statement handler (stmt) given to EXECUTE
ERROR 1243 (HY000) at line 96: Unknown prepared statement handler (stmt) given to DEALLOCATE PREPARE
大致问题：一个未知的变量在查看,没有明白

查看master.err 错误日志

2018-11-16 19:07:21 86997 [ERROR] Column count of performance_schema.events_waits_current is wrong. Expected 19, found 16. The table is probably corrupted
2018-11-16 19:07:21 86997 [ERROR] Column count of performance_schema.events_waits_history is wrong. Expected 19, found 16. The table is probably corrupted
2018-11-16 19:07:21 86997 [ERROR] Column count of performance_schema.events_waits_history_long is wrong. Expected 19, found 16. The table is probably corrupted
在查看使用mysql --version 输出为

mysql Ver 14.14 Distrib 5.5.11, for Linux (x86_64) using EditLine wrapper

在数据库里面查看 mysql version()

+------------+
| version() |
+------------+
| 5.6.42-log |
+------------+
感觉有点奇怪呀，为什么出现这样的现