[client] port = 3306 socket = /run/mysqld/sock/mysql [mysqld_safe] nice = 0 socket = /run/mysqld/sock/mysql [mysqld] # chroot = /var/lib/mysql/ # ssl-ca=/etc/mysql/cacert.pem # ssl-cert=/etc/mysql/server-cert.pem # ssl-key=/etc/mysql/server-key.pem basedir = /usr bind-address = 127.0.0.1 #binlog_do_db = include_database_name #binlog_ignore_db = include_database_name datadir = /home/mysql expire_logs_days = 10 #general_log = 1 #general_log_file = /var/log/mysql/mysql.log key_buffer = 16M lc-messages-dir = /usr/share/mysql #log-queries-not-using-indexes #log_bin = /var/log/mysql/mysql-bin.log #log_slow_queries = /var/log/mysql/mysql-slow.log #long_query_time = 2 max_allowed_packet = 16M max_binlog_size = 100M #max_connections = 100 myisam-recover = BACKUP #pid-file = /run/mysqld/pid/mysql port = 3306 query_cache_limit = 1M query_cache_size = 16M #server-id = 1 skip-external-locking #socket = /run/mysqld/sock/mysql #table_cache = 64 thread_cache_size = 8 #thread_concurrency = 10 thread_stack = 192K tmpdir = /tmp user = mysql [mysqldump] max_allowed_packet = 16M quick quote-names [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M !includedir /etc/mysql/conf.d/