Here is my full /etc/mysql/my.cnf
[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 #log = /var/log/mysql.log #log = /var/log/mysql/mysql.log basedir = /usr datadir = /mysql/data 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 query_cache_limit = 1048576 query_cache_size = 16777216 query_cache_type = 1 #log-slow-queries = /var/log/mysql/mysql-slow.log #server-id = 1 log-bin = /var/log/mysql/mysql-bin.log max_binlog_size = 104857600 #binlog-do-db = include_database_name #binlog-ignore-db = include_database_name #chroot = /var/lib/mysql/ #ssl-ca=/etc/mysql/cacert.pem #ssl-cert=/etc/mysql/server-cert.pem #ssl-key=/etc/mysql/server-key.pem # error logging log-error = /var/log/mysql.err log-warnings = 2 [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] #no-auto-rehash # faster start of mysql but no tab completition [isamchk] key_buffer = 16M dd -- David Dooling -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
