etc/mysql/my.cnf

   1 [client]
   2 #local-infile = 0
   3 port = 3306
   4 socket = /run/mysqld/sock/mysql
   5 [mysqld_safe]
   6 nice = 0
   7 socket = /run/mysqld/sock/mysql
   8 [mysqld]
   9 # chroot = /var/lib/mysql/
  10 # ssl-ca=/etc/mysql/cacert.pem
  11 # ssl-cert=/etc/mysql/server-cert.pem
  12 # ssl-key=/etc/mysql/server-key.pem
  13 basedir = /usr
  14 bind-address = 127.0.0.1
  15 # binlog_do_db = include_database_name
  16 # binlog_ignore_db = include_database_name
  17 datadir = /home/mysql
  18 expire_logs_days = 10
  19 # general_log = 1
  20 # general_log_file = /var/log/mysql/mysql.log
  21 key_buffer = 16M
  22 lc-messages-dir = /usr/share/mysql
  23 local-infile = 0
  24  # NOTE: disable the use of the "LOAD DATA LOCAL INFILE" command,
  25  # which will help to prevent unauthorized reading from local files.
  26  # This is especially important when new SQL injection vulnerabilities
  27  # in PHP applications are found.
  28 # log-queries-not-using-indexes
  29 # log_bin = /var/log/mysql/mysql-bin.log
  30 # log_slow_queries = /var/log/mysql/mysql-slow.log
  31 # long_query_time = 2
  32 max_allowed_packet = 16M
  33 max_binlog_size = 100M
  34 # max_connections = 100
  35 myisam-recover = BACKUP
  36 # pid-file = /run/mysqld.pid
  37 plugin-load = auth_socket=auth_socket.so
  38 port = 3306
  39 query_cache_limit = 1M
  40 query_cache_size = 16M
  41 # server-id = 1
  42 skip-external-locking
  43 skip-networking
  44 skip-show-database
  45 # socket = /run/mysqld/sock/mysql
  46 # table_cache = 64
  47 thread_cache_size = 8
  48 # thread_concurrency = 10
  49 thread_stack = 192K
  50 tmpdir = /tmp
  51 user = mysql
  52 [mysqldump]
  53 max_allowed_packet = 16M
  54 quick
  55 quote-names
  56 [mysql]
  57 # no-auto-rehash # NOTE: faster start of mysql but no tab completition
  58 [isamchk]
  59 key_buffer = 16M
  60 !includedir /etc/mysql/conf.d/
  61
  62 # vim: ft=conf