My.cnf examples

From Wiki
Jump to: navigation, search
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
bind-address=127.0.0.1
default-storage-engine = InnoDB
log-bin=/tmp/mysql-binary-log
external-locking 
max_connections = 250
max_user_connections = 100

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid