MySQL 5.6 Multi-instance Mysqld_multi stop cannot shut down the database

1. Description

According to the needs of the business, from the perspective of reasonable use of hardware resources, production database to prepare some of the business running many instances, in the process of testing encountered a small problem, record.

2.vi/etc/my.cnf

[Mysqld_multi]mysqld=/usr/bin/mysqld_safemysqladmin=/usr/bin/mysqladminuser = Rootpassword = Rootlog=/tmp/multi.lo G..............................

3. Error message

# Mysqld_multi Stop 3307--3307 stands for GNR Group numbers

The user, password, and permission check are OK when the database is executed.

Warning:using a password on the command line interface can is insecure./usr/bin/mysqladmin:connect to server at ' Localho St ' Failederror: ' Access denied for user ' root ' @ ' localhost ' (using password:yes) ' Mysqld_multi log file version 2.16; run:wed Dec 14 15:31:32 2016

4. Handling Methods

# which mysqld_multi/usr/bin/mysqld_multi# Vi/usr/bin/mysqld_multi

My $com = Join ', ' my_print_defaults ', @defaults_options, $group; To be replaced by: my $com = Join ', ' my_print_defaults-s ', @defaults_options, $group;

5. Successful re-execution

# Mysqld_multi Stop 3307# mysqld_multi reportreporting MySQL serversmysql server from group:mysqld3307 are not running

Most of the company's host server resources are relatively idle, especially the database server, how to ensure that the business normal situation for the company

Saving money is a question that needs to be considered, and every department needs to think about it. Money is the life of the rich, the life of ordinary people without money,

In other words, business pressure comes up, it is likely that the company's ability to make money also comes up, the time to do the adjustment is not too late, gradual, structural design is so, continuous improvement, evolution, the existence is reasonable.

MySQL 5.6 Multi-instance Mysqld_multi stop cannot shut down the database