centos 7 mysql 中文_centos7中mysql不能输入中文问题的解决

首先在数据库里面输入

mysql> show variables like‘%char%‘

-> ;

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

| Variable_name | Value |

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

| character_set_client | utf8 |

| character_set_connection | utf8 |

| character_set_database | latin1 |

| character_set_filesystem | binary |

| character_set_results | utf8 |

| character_set_server | latin1 |

| character_set_system | utf8 |

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

| validate_password_special_char_count | 1 |

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

9 rows in set (0.00 sec)

mysql> set character_set_database=utf8; #更改编码属性

Query OK, 0 rows affected, 1 warning (0.00 sec)