mysql修改数据库字符集和校对规则，怎样修改MySQL数据库的字符集

对于mysql修改数据库字符集和校对规则，怎样修改MySQL数据库的字符集，很多网友还不是很明白，今天艾巴小编收集了这方面的知识，就将其分享出来。

操作方法：

1. Log in to MySQLmysql -u root -p

2. to see which databases in the relational database display the database; We choose cms to use cms to view the current character set of the Center of Mass System (the abbreviation of center of mass system) database and display variables similar to"character_set_database";

3. appears, and it is necessary to replace gb2313 with utf8alter database cms character set"UTF8";

4. View the current character set of the Center of Mass System database, and display variables similar to' character _ set _ database'

5.使用显示字符集；看看MySQL目前支持的所有字符集，从而选出你需要的那个。

特别提示：

请注意正确填写姓名。

以上知识分享到此为止，希望能够帮助到大家！