mysql或mariadb设置UTF8

mysql连接，执行语句：

mysql> show variables like '%character%';
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

mysql> show variables like '%collation%'; 
+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_general_ci |
| collation_database   | utf8_general_ci |
| collation_server     | utf8_general_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)

如果不是上述结果，那么需要配置mysql的my.cnf
[mysqld] 中增加
character-set-server=utf8

[mysqld_safe] 中增加
default-character-set=utf8

[mysql] 中增加
default-character-set=utf8

另外如果想要msyqldump免密码的话，需要配置：
[mysqldump]
host=localhost
user=root
password=‘xxxxxxxxxxxxx’