1 查看当前字符集

  1. show variables like 'character_set%';

2 输入下列命令进行一个一个修改即可。

  1. mysql> set character_set_client=utf8;
  2. Query OK, 0 rows affected (0.00 sec)
  3. mysql> set character_set_connection=utf8;
  4. Query OK, 0 rows affected (0.00 sec)
  5. mysql> set character_set_database=utf8;
  6. Query OK, 0 rows affected (0.00 sec)
  7. mysql> set character_set_results=utf8;
  8. Query OK, 0 rows affected (0.00 sec)
  9. mysql> set character_set_server=utf8;
  10. Query OK, 0 rows affected (0.00 sec)
  11. mysql> set character_set_system=utf8;
  12. Query OK, 0 rows affected (0.01 sec)
  13. mysql> set collation_connection=utf8;
  14. Query OK, 0 rows affected (0.01 sec)
  15. mysql> set collation_database=utf8;
  16. Query OK, 0 rows affected (0.01 sec)
  17. mysql> set collation_server=utf8;
  18. Query OK, 0 rows affected (0.01 sec)