File: //etc/my.cnf
[mysqld]
back_log=120
max_connections=120
#bind-address=127.0.0.1
max_allowed_packet=32M
thread_stack=256K
#key_buffer=
#net_buffer_length=
performance_schema=OFF
long_query_time=30
#old-password=
interactive_timeout=100
default-storage-engine=MyISAM
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=30000
#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=800
table_definition_cache=600
innodb_buffer_pool_size=256M
max-connect-errors=10000
#default-time-zone=-02:00
[mysqld_safe]
log-error=/var/log/mysqld.log
#pid-file=
[mysqld]
back_log=120
max_connections=120
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