Home >Database >Mysql Tutorial >解析mysql修改为utf8后仍然有乱码的问题
解析mysql修改为utf8后仍然有乱码的问题
- WBOYOriginal
- 2016-06-07 16:16:521111browse
解决方法： 1、找到mysql安装目录c:Program FilesMySQLMySQL Server 5.5下的my.ini 2、修改一下三处，注意通常只能搜索到[mysql]和[mysqld]两处，[client]处需要增加： [client] default-character-set=utf8 [mysql] default-character-set=utf8 [mysqld] de
解决方法：
1、找到mysql安装目录c:Program FilesMySQLMySQL Server 5.5下的my.ini
2、修改一下三处，注意通常只能搜索到[mysql]和[mysqld]两处，，[client]处需要增加：
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
default-character-set=utf8
3、保存my.ini，在控制面板里找到服务，重启mysql服务。
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL出现Can't create/write to file 'C:WindowsTEMP#sql_990_Next article：用expect免密码进入MySQL命令模式