Mysql数据库存入数据乱码读取乱码情况处理

柔情只为你懂 2022-05-24 07:56 331阅读 0赞

找到mysql数据库安装目录 下的my.ini文件

在\[mysqld\] 下面加上character-set-server=utf8 这一段话就解决问题了

然后重启数据库服务

![70][]

![70 1][]

net stop mysql  停止数据库服务

net start mysql 重启数据库服务

\-----------------------------------------------------------------

\# For advice on how to change settings please see  
\# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html  
\# \*\*\* DO NOT EDIT THIS FILE. It's a template which will be copied to the  
\# \*\*\* default location during install, and will be replaced if you  
\# \*\*\* upgrade to a newer version of MySQL.  
  
  
\[mysqld\]  
character-set-server=utf8  
\# Remove leading \# and set to the amount of RAM for the most important data  
\# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.  
\# innodb\_buffer\_pool\_size = 128M  
  
  
\# Remove leading \# to turn on a very important data integrity option: logging  
\# changes to the binary log between backups.  
\# log\_bin  
  
  
\# These are commonly set, remove the \# and set as required.  
\# basedir = D:\\mysql\\mysql-5.6.40-winx64  
\# datadir = D:\\mysql\\mysql-5.6.40-winx64\\data  
\# port = .....  
\# server\_id = .....  
  
  
  
  
\# Remove leading \# to set options mainly useful for reporting servers.  
\# The server defaults are faster for transactions and fast SELECTs.  
\# Adjust sizes as needed, experiment to find the optimal values.  
\# join\_buffer\_size = 128M  
\# sort\_buffer\_size = 2M  
\# read\_rnd\_buffer\_size = 2M   
  
  
sql\_mode=NO\_ENGINE\_SUBSTITUTION,STRICT\_TRANS\_TABLES

[70]: /images/20220524/adacf8bcacc84985955089d0e8244d56.png
[70 1]: /images/20220524/08647b7845164982a5b35b7b2a211abb.png