File: //etc/my.cnf
[mysqld]
bind-address=0.0.0.0
max_allowed_packet=64M
thread_stack=256K
#key_buffer=
#net_buffer_length=
#performance_schema=
long_query_time=30
#old-password=
interactive_timeout=100
default-storage-engine=InnoDB
innodb_file_per_table=1
wait_timeout=100
#connect_timeout=
key_buffer_size=16M
#join_buffer=
#join_buffer_size=
#table_cache=
#sort_buffer=
#record_buffer=
#thread_cache_size=
#max_user_connections=
#thread_concurrency=
#myisam_sort_buffer_size=
#max_heap_table_size=
#tmp_table_size=
#query_cache_limit=
#query_cache_size=
#query_cache_type=
datadir=/var/lib/mysql
socket=/var/run/mysqld/mysql.sock
symbolic-links=1
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
transaction-isolation=READ-COMMITTED
table_open_cache=2000
table_definition_cache=1300
innodb_buffer_pool_size=256M
max-connect-errors=10000
max_connections=130
[mysqld_safe]
log-error=/var/log/mysqld.log
#pid-file=
[mysqld]
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'
character-set-server=utf8
[client]
default-character-set=utf8
socket=/var/run/mysqld/mysql.sock
[mysql]
default-character-set=utf8