my.ini 文件解决mysql无法存储中文字符问题

逃离我推掉我的手 2022-08-20 06:12 164阅读 0赞

这个my.ini文件是在mysql文件目录下直接找到的，本来想改my.ini文件中的内容。结果在网络上到处找都没有找到，如果你找到my\_default.ini，修改完毕之后可以将其直接改名为my.ini，然后放在mysql文件一级目录下直接使用。具体位置：

![Center][]

[show][] [variables][show] [like][] 'character\_set\_%'

[http://www.oschina.net/question/565065\_86411][http_www.oschina.net_question_565065_86411]

my.ini正文：

\# MySQL Server Instance Configuration File

\# ----------------------------------------------------------------------  
\# Generated by the MySQL Server Instance Configuration Wizard  
\#  
\#  
\# Installation Instructions  
\# ----------------------------------------------------------------------  
\#  
\# On Linux you can copy this file to /etc/my.cnf to set global options,  
\# mysql-data-dir/my.cnf to set server-specific options  
\# (@localstatedir@ for this installation) or to  
\# ~/.my.cnf to set user-specific options.  
\#  
\# On Windows you should keep this file in the installation directory  
\# of your server (e.g. C:\\Program Files\\MySQL\\MySQL Server 4.1). To  
\# make sure the server reads the config file use the startup option  
\# "--defaults-file".  
\#  
\# To run run the server from the command line, execute this in a  
\# command line shell, e.g.  
\# mysqld --defaults-file="C:\\Program Files\\MySQL\\MySQL Server 4.1\\my.ini"  
\#  
\# To install the server as a Windows service manually, execute this in a  
\# command line shell, e.g.  
\# mysqld --install MySQL41 --defaults-file="C:\\Program Files\\MySQL\\MySQL Server 4.1\\my.ini"  
\#  
\# And then execute this in a command line shell to start the server, e.g.  
\# net start MySQL41  
\#  
\#  
\# Guildlines for editing this file  
\# ----------------------------------------------------------------------  
\#  
\# In this file, you can use all long options that the program supports.  
\# If you want to know the options a program supports, start the program  
\# with the "--help" option.  
\#  
\# More detailed information about the individual options can also be  
\# found in the manual.  
\#  
\#  
\# CLIENT SECTION  
\# ----------------------------------------------------------------------  
\#  
\# The following options will be read by MySQL client applications.  
\# Note that only client applications shipped by MySQL are guaranteed  
\# to read this section. If you want your own MySQL client program to  
\# honor these values, you need to specify it as an option during the  
\# MySQL client library initialization.  
\#  
\[client\]  
  
port=3306  
  
  
\# SERVER SECTION  
\# ----------------------------------------------------------------------  
\#  
\# The following options will be read by the MySQL Server. Make sure that  
\# you have installed the server correctly (see above) so it reads this  
\# file.  
\#  
\[wampmysqld\]  
  
\# The TCP/IP Port the MySQL Server will listen on  
port=3306  
  
  
\#Path to installation directory. All paths are usually resolved relative to this.  
basedir=D:/wamp/mysql  
  
\#log file  
log-error=D:/wamp/logs/mysql\_error.log  
  
\#Path to the database root  
datadir=D:/wamp/mysql/data  
  
\# The default character set that will be used when a new schema or table is  
\# created and no character set is defined  
default-character-set=latin1  
  
\# The default storage engine that will be used when create new tables when  
default-storage-engine=INNODB  
  
\# The maximum amount of concurrent sessions the MySQL server will  
\# allow. One of these connections will be reserved for a user with  
\# SUPER privileges to allow the administrator to login even if the  
\# connection limit has been reached.  
max\_connections=255  
  
\# Query cache is used to cache SELECT results and later return them  
\# without actual executing the same query once again. Having the query  
\# cache enabled may result in significant speed improvements, if your  
\# have a lot of identical queries and rarely changing tables. See the  
\# "Qcache\_lowmem\_prunes" status variable to check if the current value  
\# is high enough for your load.  
\# Note: In case your tables change very often or if your queries are  
\# textually different every time, the query cache may result in a  
\# slowdown instead of a performance improvement.  
query\_cache\_size=8M  
  
\# The number of open tables for all threads. Increasing this value  
\# increases the number of file descriptors that mysqld requires.  
\# Therefore you have to make sure to set the amount of open files  
\# allowed to at least 4096 in the variable "open-files-limit" in  
\# section \[mysqld\_safe\]  
table\_cache=510  
  
\# Maximum size for internal (in-memory) temporary tables. If a table  
\# grows larger than this value, it is automatically converted to disk  
\# based table This limitation is for a single table. There can be many  
\# of them.  
tmp\_table\_size=13M  
  
  
\# How many threads we should keep in a cache for reuse. When a client  
\# disconnects, the client's threads are put in the cache if there aren't  
\# more than thread\_cache\_size threads from before.  This greatly reduces  
\# the amount of thread creations needed if you have a lot of new  
\# connections. (Normally this doesn't give a notable performance  
\# improvement if you have a good thread implementation.)  
thread\_cache\_size=12  
  
\#\*\*\* MyISAM Specific options  
  
\# The maximum size of the temporary file MySQL is allowed to use while  
\# recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.  
\# If the file-size would be bigger than this, the index will be created  
\# through the key cache (which is slower).  
myisam\_max\_sort\_file\_size=100G  
  
\# If the temporary file used for fast index creation would be bigger  
\# than using the key cache by the amount specified here, then prefer the  
\# key cache method.  This is mainly used to force long character keys in  
\# large tables to use the slower key cache method to create the index.  
myisam\_max\_extra\_sort\_file\_size=100G  
  
\# If the temporary file used for fast index creation would be bigger  
\# than using the key cache by the amount specified here, then prefer the  
\# key cache method.  This is mainly used to force long character keys in  
\# large tables to use the slower key cache method to create the index.  
myisam\_sort\_buffer\_size=8M  
  
\# Size of the Key Buffer, used to cache index blocks for MyISAM tables.  
\# Do not set it larger than 30% of your available memory, as some memory  
\# is also required by the OS to cache rows. Even if you're not using  
\# MyISAM tables, you should still set it to 8-64M as it will also be  
\# used for internal temporary disk tables.  
key\_buffer\_size=9M  
  
\# Size of the buffer used for doing full table scans of MyISAM tables.  
\# Allocated per thread, if a full scan is needed.  
read\_buffer\_size=64K  
read\_rnd\_buffer\_size=256K  
  
\# This buffer is allocated when MySQL needs to rebuild the index in  
\# REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE  
\# into an empty table. It is allocated per thread so be careful with  
\# large settings.  
sort\_buffer\_size=203K  
  
  
\#\*\*\* INNODB Specific options \*\*\*  
  
  
\# Use this option if you have a MySQL server with InnoDB support enabled  
\# but you do not plan to use it. This will save memory and disk space  
\# and speed up some things.  
\#skip-innodb  
  
\# Additional memory pool that is used by InnoDB to store metadata  
\# information.  If InnoDB requires more memory for this purpose it will  
\# start to allocate it from the OS.  As this is fast enough on most  
\# recent operating systems, you normally do not need to change this  
\# value. SHOW INNODB STATUS will display the current amount used.  
innodb\_additional\_mem\_pool\_size=2M  
  
\# If set to 1, InnoDB will flush (fsync) the transaction logs to the  
\# disk at each commit, which offers full ACID behavior. If you are  
\# willing to compromise this safety, and you are running small  
\# transactions, you may set this to 0 or 2 to reduce disk I/O to the  
\# logs. Value 0 means that the log is only written to the log file and  
\# the log file flushed to disk approximately once per second. Value 2  
\# means the log is written to the log file at each commit, but the log  
\# file is only flushed to disk approximately once per second.  
innodb\_flush\_log\_at\_trx\_commit=1  
  
\# The size of the buffer InnoDB uses for buffering log data. As soon as  
\# it is full, InnoDB will have to flush it to disk. As it is flushed  
\# once per second anyway, it does not make sense to have it very large  
\# (even with long transactions).  
innodb\_log\_buffer\_size=1M  
  
\# InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and  
\# row data. The bigger you set this the less disk I/O is needed to  
\# access data in tables. On a dedicated database server you may set this  
\# parameter up to 80% of the machine physical memory size. Do not set it  
\# too large, though, because competition of the physical memory may  
\# cause paging in the operating system.  Note that on 32bit systems you  
\# might be limited to 2-3.5G of user level memory per process, so do not  
\# set it too high.  
innodb\_buffer\_pool\_size=15M  
  
\# Size of each log file in a log group. You should set the combined size  
\# of log files to about 25%-100% of your buffer pool size to avoid  
\# unneeded buffer pool flush activity on log file overwrite. However,  
\# note that a larger logfile size will increase the time needed for the  
\# recovery process.  
innodb\_log\_file\_size=10M  
  
\# Number of threads allowed inside the InnoDB kernel. The optimal value  
\# depends highly on the application, hardware as well as the OS  
\# scheduler properties. A too high value may lead to thread thrashing.  
innodb\_thread\_concurrency=8

[Center]: /images/20220731/a368304bc6864c25a76ec231a6ecdde2.png
[show]: http://120.27.35.231/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fshow-variables.html&server=0&token=b9e99e01ed3c6114dca2cbf4e03c3a35
[like]: http://120.27.35.231/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fstring-comparison-functions.html&server=0&token=b9e99e01ed3c6114dca2cbf4e03c3a35#operator_like
[http_www.oschina.net_question_565065_86411]: http://www.oschina.net/question/565065_86411