设置mysql数据库中默认编码方式utf8

查看mysql数据库中默认编码方式

show variables like 'character%';

1	show variables like 'character%';

设置mysql数据库中默认编码方式

set character_set_client = utf8;
set character_set_connection = utf8;
set character_set_database = utf8;
set character_set_results = utf8;
set character_set_server = utf8;

set character_set_client = utf8;

set character_set_connection = utf8;

set character_set_database = utf8;

set character_set_results = utf8;

set character_set_server = utf8;