Page tree

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of metadata
Go to start of metadata

This was created from a default Ubuntu 14 MySQL Installation

cat << 'EOL'>/etc/mysql/my.cnf
#
# The MySQL database server configuration file.
#
[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
bind-address            = 127.0.0.1
#log_bin                        = /var/log/mysql/mysql-bin.log
#binlog_do_db           = include_database_name
#server-id              = 1


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
lc-messages-dir = /usr/share/mysql
skip-external-locking
skip-external-locking


key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 192K
thread_cache_size       = 8
myisam-recover         = BACKUP
#max_connections        = 100
#table_cache            = 64
#thread_concurrency     = 10
query_cache_limit       = 1M
query_cache_size        = 16M
log_error = /var/log/mysql/error.log
#log_slow_queries       = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes

expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_ignore_db       = include_database_name
#ssl-ca=/etc/mysql/cacert.pem
#ssl-cert=/etc/mysql/server-cert.pem
#ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash 

[isamchk]
key_buffer              = 16M

!includedir /etc/mysql/conf.d/
EOL

  • No labels