mysql_install_db --user=mysql
cat > /etc/my.cnf <
# The following options will be passed to all MySQL clients
[client]
#password= your_password
port= 3306
socket= /var/lib/mysql/mysql.sock
default-character-set=utf8
# The MySQL server
[mysqld]
character-set-server=utf8
language=/usr/share/mysql/english/
port= 3306
socket= /var/lib/mysql/mysql.sock
skip-name-resolve
#skip-locking
max_connect_errors=1000
max_connections=1000
max_allowed_packet = 10M
key_buffer = 128M
sort_buffer_size = 64M
net_buffer_length = 128K
read_buffer_size = 128M
read_rnd_buffer_size = 128M
myisam_sort_buffer_size = 128M
key_buffer_size=128M
table_open_cache=128
table_cache=128
thread_cache_size=64
query_cache_size=200M
query_cache_limit=200M
table_definition_cache=128
myisam_data_pointer_size=7
delayed_queue_size=256
preload_buffer_size=65536
delayed_queue_size=20
preload_buffer_size=1024
innodb_read_ahead_threshold=2
innodb_buffer_pool_size=128M;
innodb_additional_mem_pool=16M;
thread_concurrency = 2
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
EOF