Bug #81682 mysqld_multi can not work if i define a shutdown account with password

• Submitted: 2 Jun 2016 3:01
• Modified: 2 Jun 2016 8:51
• Reporter: h h
• Status: Duplicate
• Category: MySQL Server: Command-line Clients
• Severity: S2 (Serious)
• Version: 5.7.12
• OS: Linux (Centos6.5)
• CPU Architecture: Any
• Tags: mysqladmin, mysqld_multi

[2 Jun 2016 3:01] h h

Description:
mysql_multi can not stop any instance if you have a shutdown account with password, because mysql_mulit depend my_print_defaults get all options which is defined in my.cnf,but it will shadow password,and cause mysql server connection always fail !

# my_print_defaults mysqld_multi
--mysqld=/usr/bin/mysqld_safe
--mysqladmin=/usr/bin/mysqladmin
--user=multi_admin
--password=*****
--log=/var/log/mysqld_multi.log

How to repeat:
create a instance,start it with mysqld_multi

Suggested fix:
one way to avoid this situation is set a shutdown account with empty password,don't do it in product server

[2 Jun 2016 8:51] MySQL Verification Team

Hello!

Thank you for the report.
This is most likely duplicate of Bug #77227.

Thanks,
Umesh