# mysqld_multi settings

## create two mysql datadir.
---
```
$ mysqld --initialize --datadir=/var/lib/mysql11 --user=mysql
$ mysqld --initialize --datadir=/var/lib/mysql12 --user=mysql
```

## create my.cnf
```
[mysqld_multi]
mysqld     = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user       = root
password   = password

[mysqld]
# for innodb
innodb_buffer_pool_size=64M
innodb_flush_method=O_DIRECT

# loggging
slow_query_log
slow_query_log_file=slow.log
long_query_time=1.0
log-queries-not-using-indexes

general_log
general_log_file=general.log

# for gtid replication
gtid_mode=ON
log-slave-updates
enforce-gtid-consistency

[mysqld11]
port=3306
socket=/var/lib/mysql11/mysql.sock
datadir=/var/lib/mysql11
server_id=1
log-error=/var/log/mysql11.log
pid-file=/var/lib/mysql11/mysql.pid
log-bin=mysql11-bin
log-bin-index=mysql11-bin-index

[mysqld12]
port=3307
socket=/var/lib/mysql12/mysql.sock
datadir=/var/lib/mysql12
log-error=/var/log/mysql12.log
pid-file=/var/lib/mysql12/mysql12.pid
server_id=2
log-bin=mysql12-bin
log-bin-index=mysql12-bin-index

```

## start mysqld_multi

```
$ mysqld_multi start
$ mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld11 is running
MySQL server from group: mysqld12 is running
```

## change password
```
mysqladmin -uroot -p -S /var/lib//mysql11/mysql.sock password
mysqladmin -uroot -p -S /var/lib//mysql12/mysql.sock password
```

## stop mysqld_multi

```
mysqld_multi --password=password stop
```
note : my.cnf in mysqld_multi section value "password" is masked by mysql_print_defualt(That's *********).
       Because of that mysqld_multi stop is not work.
       You must be add --password=password.