Zabbix安装报mysql数据库字符集问题？
环境 Zabbix4.4 , mySql 5.7
报错如下，看了一遍mysql的字符集也没觉得有问题，请教安装过的达人，能否指点一下问题出在哪儿？
拿其中一张表看了下字符集，如下：
mysql> SELECT table_name AS 表名, table_type AS 类型, engine AS 引擎, VERSION as 版本, TABLE_COLLATION AS 字符集 FROM information_schema.tables where table_name ='acknowledges' ORDER BY table_name DEESC; | ||||
|---|---|---|---|---|
| 表名 | 类型 | 引擎 | 版本 | 字符集 |
| acknowledges | BASE TABLE | InnoDB | 10 | utf8_general_ci |
1 row in set (0.00 sec)
数据库字符集：
| mysql> show create database zabbix; | |
|---|---|
| Database | Create Database |
| zabbix | CREATE DATABASE zabbix /!40100 DEFAULT CHARACTER SET utf8 / |
mysql下字符集配置情况：
mysql> show variables like 'collation%';
No connection. Trying to reconnect...
Connection id: 13
| Current database: NONE | |
|---|---|
| Variable_name | Value |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| mysql> show variables like 'character_set%'; | |
|---|---|
| Variable_name | Value |
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
3同行回答
https://www.zabbix.com/forum/zabbix-help/396532-zabbix-database-character-set-error
我遇到和你一样的问题, 3.4升级5.0遇到的, 按上面的操作解决了
收起浏览2449