也可以使用下面方式来修改 mysql> show global variables like 'character_set_server'; +----------------------+--------+ | Variable_name        | Value  | +----------------------+--------+ | character_set_server | latin1 | +----------------------+--------+ 1 row in set (0.00 sec) mysql> set @@global.character_set_server=gbk; Query OK, 0 rows affected (0.00 sec) mysql> show global variables like 'character_set_server'; +----------------------+-------+ | Variable_name        | Value | +----------------------+-------+ | character_set_server | gbk   | +----------------------+-------+ 1 row in set (0.01 sec) --会话级别 mysql> set session character_set_server='utf8'; Query OK, 0 rows affected (0.00 sec) mysql> show global variables like '%server%'; +----------------------+----------------+ | Variable_name        | Value          | +----------------------+----------------+ | character_set_server | gbk            | | collation_server     | gbk_chinese_ci | | server_id            | 1              | +----------------------+----------------+ 3 rows in set (0.00 sec) -- show  variables查询的是会话级别的参数 mysql> show  variables like '%server%'; +----------------------+-----------------+ | Variable_name        | Value           | +----------------------+-----------------+ | character_set_server | utf8            | | collation_server     | utf8_general_ci | | server_id            | 1               | +----------------------+-----------------+ 3 rows in set (0.00 sec) mysql> show session variables like '%server%'; +----------------------+-----------------+ | Variable_name        | Value           | +----------------------+-----------------+ | character_set_server | utf8            | | collation_server     | utf8_general_ci | | server_id            | 1               | +----------------------+-----------------+ 3 rows in set (0.00 sec) 即使是使用set global命令设置的参数，在数据库重启后，相关的参数也会失效；如果想让参数永久生效，可以将参数写在配置文件里面。 [root@localhost mysql]# vim /etc/my.cnf