-
Notifications
You must be signed in to change notification settings - Fork 3
/
Copy path.my.cnf
41 lines (38 loc) · 1 KB
/
.my.cnf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
[mysql]
default-character-set=utf8
prompt='\\u: [\\d] \\r:\\m \\P> '
auto-rehash
show-warnings
pager = grcat ~/.grcat
[mysqld_multi]
mysqld = /usr/local/opt/mysql56/bin/mysqld_safe
mysqladmin = /usr/local/opt/mysql56/bin/mysqladmin
user = multi_admin
password = multipass
[mysqld1]
server-id = 1
user = root
port = 3306
datadir = /usr/local/var/mysql1
socket = /tmp/mysql.sock1
pid-file = /tmp/mysqld.pid1
language = /usr/local/share/mysql/japanese
sync_binlog = 1
log-bin = mysql-bin
log-bin-index = mysql-bin
relay-log = relay-bin
relay-log-index = relay-bin
[mysqld2]
server-id = 2
user = root
port = 3307
datadir = /usr/local/var/mysql2
socket = /tmp/mysql.sock2
pid-file = /tmp/mysqld.pid2
language = /usr/local/share/mysql/japanese
read_only
log-slave-updates
log-bin = mysql-bin
log-bin-index = mysql-bin
relay-log = relay-bin
relay-log-index = relay-bin