mysql myini 中文_mysql /etc/my.ini支持中文配置

etc/my.ini

[client]

#password   = your_password

port        = 3306

socket      = /var/lib/mysql/mysql.sock

default-character-set=utf8

# The MySQL server

[mysqld]

port        = 3306

socket      = /var/lib/mysql/mysql.sock

skip-locking

key_buffer_size = 384M

max_allowed_packet = 1M

table_open_cache = 512

sort_buffer_size = 2M

read_buffer_size = 2M

read_rnd_buffer_size = 8M

myisam_sort_buffer_size = 64M

thread_cache_size = 8

query_cache_size = 32M

# Try number of CPU's*2 for thread_concurrency

thread_concurrency = 8

default-character-set=utf8

init_connect='SET NAMES utf8'

max_connections=2000

max_connect_errors=2000

skip-name-resolve

[mysqldump]

quick

max_allowed_packet = 16M

[mysql]

no-auto-rehash

# Remove the next comment character if you are not familiar with SQL

#safe-updates

default-character-set=utf8

[myisamchk]

key_buffer_size = 256M

sort_buffer_size = 256M

read_buffer = 2M

write_buffer = 2M

[mysqlhotcopy]

interactive-timeout