Difference between revisions of "Default mysql.cnf"
From Kolmisoft Wiki
Jump to navigationJump to search
(New page: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user =...) |
|||
Line 1: | Line 1: | ||
[client] | |||
port = 3306 | |||
socket = /var/run/mysqld/mysqld.sock | |||
[ | [mysqld_safe] | ||
socket = /var/run/mysqld/mysqld.sock | |||
socket = /var/run/mysqld/mysqld.sock | nice = 0 | ||
[ | [mysqld] | ||
user = mysql | |||
pid-file = /var/run/mysqld/mysqld.pid | |||
socket = /var/run/mysqld/mysqld.sock | |||
port = 3306 | |||
basedir = /usr | |||
datadir = /var/lib/mysql | |||
tmpdir = /tmp | |||
language = /usr/share/mysql/english | |||
skip-external-locking | |||
bind-address = 127.0.0.1 | |||
key_buffer = 16M | |||
max_allowed_packet = 16M | |||
thread_stack = 128K | |||
thread_cache_size = 8 | |||
query_cache_limit = 1M | |||
query_cache_size = 16M | |||
log_bin = /var/log/mysql/mysql-bin.log | |||
expire_logs_days = 10 | |||
max_binlog_size = 100M | |||
skip-bdb | |||
[mysqldump] | |||
quick | |||
quote-names | |||
max_allowed_packet = 16M | max_allowed_packet = 16M | ||
[mysql] | |||
[mysql] | |||
[isamchk] | [isamchk] | ||
key_buffer = 16M | key_buffer = 16M | ||
!includedir /etc/mysql/conf.d/ | !includedir /etc/mysql/conf.d/ |
Latest revision as of 12:25, 25 February 2008
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock
[mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0
[mysqld]
user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking
bind-address = 127.0.0.1
key_buffer = 16M max_allowed_packet = 16M thread_stack = 128K thread_cache_size = 8 query_cache_limit = 1M query_cache_size = 16M log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M skip-bdb
[mysqldump] quick quote-names
max_allowed_packet = 16M
[mysql]
[isamchk] key_buffer = 16M
!includedir /etc/mysql/conf.d/