1

2

3

4

5

6

#1.從window主機路徑C:\Windows\Fonts下選擇一種自己喜歡的字體，如mysh.ttf(雅黑)；

#2.將拷貝出來的字體上傳到zabbix server網頁文件的fonts目錄下，并命名為

DejaVuSans.ttf

[root@zhu1 ~]# mv /var/www/html/fonts/DejaVuSans.ttf /var/www/html/fonts/DejaVuSans.ttf.old

mv/var/www/html/fonts/mysh.ttf /var/www/html/fonts/DejaVuSans.ttf

#這樣便能解決這個亂碼問題

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

mysql> show create database zabbix;

+----------+-------------------------------------------------------------------+

| Database | Create Database                                                   |

+----------+-------------------------------------------------------------------+

| zabbix   | CREATE DATABASE `zabbix` /*!40100 DEFAULT CHARACTER SET latin1 */ |

+----------+-------------------------------------------------------------------+

1 row inset(0.00 sec)

#安裝時在導入三個sql文件時，zabbix數據庫中創建的表的字符集也是latin1

mysql> show variables like 'character%';

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | latin1                     |

| character_set_connection | latin1                     |

| character_set_database   | latin1                     |

| character_set_filesystem | binary                     |

| character_set_results    | latin1                     |

| character_set_server     | latin1                     |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/|

+--------------------------+----------------------------+

8 rows inset(0.00 sec)

1

[root@zhu1 ~]# mysqldump -uroot -p123456  zabbix > zabbix.sql

1

[root@zhu1 ~]# sed -i 's/latin1/utf8/g' zabbix.sql

1

mysql> drop database zabbix;

1

2

3

4

5

6

[root@zhu1 ~]# vim /etc/my.cnf

[mysqld]

log-bin

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

default-character-set= utf8 #添加該項 or

character-set-server=utf8 

1

[root@zhu1 ~]# mysql -uroot -p123456 zabbix < zabbix.sql

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

mysql> show create database zabbix;

+----------+-----------------------------------------------------------------+

| Database | Create Database                                                 |

+----------+-----------------------------------------------------------------+

| zabbix   | CREATE DATABASE `zabbix` /*!40100 DEFAULT CHARACTER SET utf8 */ |

+----------+-----------------------------------------------------------------+

1 row inset(0.00 sec)

mysql> show variables like 'character%';

+--------------------------+----------------------------+

| Variable_name            | Value                      |

+--------------------------+----------------------------+

| character_set_client     | latin1                     |

| character_set_connection | latin1                     |

| character_set_database   | utf8                       |

| character_set_filesystem | binary                     |

| character_set_results    | latin1                     |

| character_set_server     | utf8                       |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/|

+--------------------------+----------------------------+

8 rows inset(0.00 sec)

1

2

3

#1.刪除zabbix數據庫

#2.設置mysql數據庫的默認字符集為utf8

#3.重新創建zabbix數據庫并導入三個sql文件

1

2

3

4

5

6

7

8

9

10

11

12

--with-charset=CHARSET

Default character set, use one of:

binary

armscii8 ascii big5 cp1250 cp1251 cp1256 cp1257

cp850 cp852 cp866 cp932 dec8 eucjpms euckr gb2312 gbk geostd8

greek hebrew hp8 keybcs2 koi8r koi8u

latin1 latin2 latin5 latin7 macce macroman

sjis swe7 tis620 ucs2 ujis utf8

--with-extra-charsets=CHARSET,CHARSET,...

Use charsets inaddition to default (none, complex,

all, or a list selected from the above sets)

#上面這兩個是編譯安裝mysql事對字符集設置的參數，當不進行設置時默認便是latin1，