Return to Snippet

Revision: 67782
at October 30, 2014 01:52 by jacktan


Initial Code
[client]
host=localhost
port=3306
user=root
password=

default-character-set=utf8
connect_timeout=2

[mysql]
max_allowed_packet=16M
tee=mysql_result.log

[mysqld]
basedir=.\\
datadir=.\\data

explicit_defaults_for_timestamp=true

port=3306
server_id=3141526

sql_mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

key_buffer_size=8M
max_allowed_packet=8M
max_connections=100
query_cache_size=0
table-open-cache=64
tmp_table_size=32M
thread_cache_size=8

log-error=error.log

character-set-server=utf8
collation-server=utf8_general_ci


default-storage-engine=INNODB
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=1M
innodb_buffer_pool_size=8M
innodb_log_file_size=22M
innodb_thread_concurrency=8

Initial URL

                                

Initial Description
`mysql-dev.ini` can be used in a developing environment and put it in the Mysql Home dir

Initial Title
A example option file for mysql in windows

Initial Tags
mysql, windows

Initial Language
MySQL