Ticket #6013: my.cnf

File my.cnf, 1.6 KB (added by joe@…, 19 years ago)

new my.cnf to avoid confusion over socket paths

Line 
1# /etc/mysql/my.cnf: The global mysql configuration file.
2
3# This file can be simultaneously placed in three places:
4# 1. /etc/mysql/my.cnf to set global options.
5# 2. /var/lib/mysql/my.cnf to set server-specific options.
6# 3. ~/.my.cnf to set user-specific options.
7#
8# One can use all long options that the program supports.
9# Run the program with --help to get a list of them.
10#
11# The following values assume you have at least 32M RAM!
12
13[client]
14#password       = my_password
15port            = 3306
16socket          = /opt/local/var/run/mysqld/mysqld.sock
17
18[safe_mysqld]
19err-log         = /opt/local/var/log/mysql/mysql.err
20pid-file        = /opt/local/var/run/mysqld/mysqld.pid
21socket          = /opt/local/var/run/mysqld/mysqld.sock
22port            = 3306
23
24[mysqld_safe]
25err-log         = /opt/local/var/log/mysql/mysql.err
26pid-file        = /opt/local/var/run/mysqld/mysqld.pid
27socket          = /opt/local/var/run/mysqld/mysqld.sock
28port            = 3306
29
30[mysqld]
31#skip-networking
32skip-innodb
33user            = mysql
34pid-file        = /opt/local/var/run/mysqld/mysqld.pid
35socket          = /opt/local/var/run/mysqld/mysqld.sock
36port            = 3306
37log             = /opt/local/var/log/mysql/mysql.log
38basedir         = /opt/local
39datadir         = /opt/local/var/db/mysql
40tmpdir          = /tmp
41language        = /opt/local/share/mysql/english
42skip-locking
43set-variable    = key_buffer=16M
44set-variable    = max_allowed_packet=1M
45set-variable    = thread_stack=128K
46
47[mysqldump]
48quick
49set-variable    = max_allowed_packet=1M
50
51[mysql]
52#no-auto-rehash # faster start of mysql but no tab completition
53
54[isamchk]
55set-variable    = key_buffer=16