mysqld_multi启动mysqld_multi report报错

Reporting MySQL servers
No groups to be reported (check your GNRs)

>mysqld_multi --example  ##查看multi配置文件格式
>[mysqld_multi]
mysqld     = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user       = multi_admin
password   = my_password

[mysqld2]
socket     = /tmp/mysql.sock2
port       = 3307
pid-file   = /usr/local/mysql/data2/hostname.pid2
datadir    = /usr/local/mysql/data2
language   = /usr/local/mysql/share/mysql/english
user       = unix_user1

[mysqld3]
mysqld     = /path/to/mysqld_safe
ledir      = /path/to/mysqld-binary/
mysqladmin = /path/to/mysqladmin
socket     = /tmp/mysql.sock3
port       = 3308
pid-file   = /usr/local/mysql/data3/hostname.pid3
datadir    = /usr/local/mysql/data3
language   = /usr/local/mysql/share/mysql/swedish
user       = unix_user2

[mysqld4]
socket     = /tmp/mysql.sock4
port       = 3309
pid-file   = /usr/local/mysql/data4/hostname.pid4
datadir    = /usr/local/mysql/data4
language   = /usr/local/mysql/share/mysql/estonia
user       = unix_user3

[mysqld6]
socket     = /tmp/mysql.sock6
port       = 3311
pid-file   = /usr/local/mysql/data6/hostname.pid6
datadir    = /usr/local/mysql/data6
language   = /usr/local/mysql/share/mysql/japanese
user       = unix_user4

my.cnf配置

[mysqld_multi]
mysqld     = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user       = root

log        = /usr/local/mysql/data/mysql_multi.log

[mysqld_master] ###
basedir    = /usr/local/mysql
datadir    = /usr/local/mysql/data/3306
socket     = /usr/local/mysql/data/3306/mysql.sock
port       = 3306
pid-file   = /usr/local/mysql/data/3306/mysql.pid
user       = mysql
server_id  = 1
log_bin    = mysql-bin

[mysqld_slave] ###
basedir    = /usr/local/mysql
datadir    = /usr/local/mysql/data/3307
socket     = /usr/local/mysql/data/3307/mysql.sock
port       = 3307
pid-file   = /usr/local/mysql/data/3307/mysql.pid
user       = mysql
server_id  = 2

按照example格式修改后：

[mysqld_multi]
mysqld     = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin
user       = root

log        = /usr/local/mysql/data/mysql_multi.log

[mysqld3306] ##
basedir    = /usr/local/mysql
datadir    = /usr/local/mysql/data/3306
socket     = /usr/local/mysql/data/3306/mysql.sock
port       = 3306
pid-file   = /usr/local/mysql/data/3306/mysql.pid
user       = mysql
server_id  = 1
log_bin    = mysql-bin

[mysqld3307] ##
basedir    = /usr/local/mysql
datadir    = /usr/local/mysql/data/3307
socket     = /usr/local/mysql/data/3307/mysql.sock
port       = 3307
pid-file   = /usr/local/mysql/data/3307/mysql.pid
user       = mysql
server_id  = 2
~

问题就解决了。

>mysqld_multi start
>mysqld_multi report

Reporting MySQL servers
MySQL server from group: mysqld3306 is running
MySQL server from group: mysqld3307 is running