]>
Commit | Line | Data |
---|---|---|
e0047254 ER |
1 | # The MySQL server configuration file. |
2 | # vim:ft=mycnf | |
3 | # | |
4 | # One can use all long options that the mysqld supports. | |
5 | # Run mysqld with --help to get a whole list of available options | |
e0047254 ER |
6 | |
7 | # This section must be the first! | |
7ce39a59 | 8 | [mysqld] |
b6369c60 ER |
9 | datadir = @clusterdir@/mysqldb/db |
10 | pid-file = @clusterdir@/mysqldb/mysql.pid | |
11 | socket = @clusterdir@/mysqldb/mysql.sock | |
2ad2f3ce | 12 | port = 3306 |
2ad2f3ce | 13 | user = mysql |
14 | ||
e0047254 | 15 | # ssl options |
fdb81f5c AM |
16 | #ssl-ca = /etc/ssl/certs/mysql{MYSQL_MAJOR}/ca-cert.pem |
17 | #ssl-cert = /etc/ssl/certs/mysql{MYSQL_MAJOR}/server-cert.pem | |
18 | #ssl-key = /etc/ssl/certs/mysql{MYSQL_MAJOR}/server-key.pem | |
e0047254 | 19 | #ssl-cipher = DHE-RSA-AES256-SHA |
b2e04e84 | 20 | |
e0047254 ER |
21 | # Don't listen on a TCP/IP port at all. This is a security enhancement, |
22 | # if all processes that need to connect to mysqld run on the same host. | |
23 | # All interaction with mysqld must be made via Unix sockets. | |
2ad2f3ce | 24 | skip-networking |
25 | ||
e0047254 ER |
26 | # IP address to bind to |
27 | #bind-address=127.0.0.1 | |
28 | ||
29 | # no dns | |
30 | #skip-name-resolve | |
31 | ||
32 | # Emergency option. Use only if you really need this. | |
33 | #skip-grant-tables | |
34 | ||
a08b7d43 | 35 | # https://dev.mysql.com/doc/refman/5.6/en/log-destinations.html |
e75dcc0d | 36 | # global option where logs be written |
a08b7d43 ER |
37 | # affects slow-query-log, general-log direcives |
38 | # Possible values: FILE, TABLE | |
39 | # NOTE: when using table, you can switch to MyISAM, but the contents is still | |
40 | # not replicated, also mysqldump will not dump data, only create table | |
41 | # statements | |
42 | #log-output = TABLE | |
e75dcc0d ER |
43 | log-output = FILE |
44 | ||
e0047254 | 45 | # mysqld error log (stderr) |
fdb81f5c | 46 | log-error = /var/log/mysql{MYSQL_MAJOR}/mysqld.log |
874af6de | 47 | log-error-verbosity = 2 |
2ebc9313 | 48 | |
e0047254 | 49 | # Log slow queries |
355e724f | 50 | slow-query-log |
fdb81f5c | 51 | slow-query-log-file = /var/log/mysql{MYSQL_MAJOR}/slow.log |
54f9e11d | 52 | |
e0047254 ER |
53 | # Log connections and queries. It slows down MySQL so it's disabled by default |
54 | #general-log | |
fdb81f5c | 55 | #general-log-file = /var/log/mysql{MYSQL_MAJOR}/query.log |
e0047254 ER |
56 | |
57 | # Log all updates. | |
fdb81f5c | 58 | #log-update = /var/log/mysql{MYSQL_MAJOR}/update |
e0047254 ER |
59 | # Log some extra information to update log |
60 | #log-long-format | |
61 | ||
62 | # Language | |
5168dba4 | 63 | #lc-messages = pl_PL |
e0047254 ER |
64 | |
65 | # Path for temporary files. Several paths may be specified, separated by a | |
66 | # colon (:), in this case they are used in a round-robin fashion. | |
67 | #tmpdir = /var/tmp | |
68 | ||
0cb1ff50 ER |
69 | # used for logs rotation or status check for replications |
70 | [client] | |
1542b54b | 71 | user = mysql_sysadmin |
7ce39a59 | 72 | password = |