windows版mysql配置--my.ini

完整配置如下：

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41

#  power by phpStudy  2014  www.phpStudy.net  官网下载最新版   [client] port=3306   [mysql]     [mysqld] port=3306 basedir="D:/soft/phpStudy/MySQL/" datadir="D:/soft/phpStudy/MySQL/data/" character-set-client-handshake=FALSE character-set-server=utf8mb4 collation-server=utf8mb4_general_ci default-storage-engine=InnoDB init_connect='set names utf8mb4' sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=512   query_cache_size=0 table_cache=256 tmp_table_size=18M   thread_cache_size=8 myisam_max_sort_file_size=64G myisam_sort_buffer_size=35M key_buffer_size=25M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K   innodb_additional_mem_pool_size=2M   innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M   innodb_buffer_pool_size=47M innodb_log_file_size=24M innodb_thread_concurrency=8 lower_case_table_names=0

　　以上配置，设置数据库编码为utf8mb4，客户端服务端都是这个编码，以及表名区分大小写(具体可看lower_case_table_name)！