In MySQL multi-instance enablement, many environments choose to use Mysqld_multi to manage multiple instances, but unfortunately, after MySQL 5.6,
Mysqld_mutli can't turn MySQL off.
The approach to this problem is first confirmed:
Mysqladmin-h127.0.0.1-p3307-umdev-p shutdown
Or
Mysqladmin-s/tmp/mysql3307.sock-umdev-p shutdown
Work is fine.
To create a user:
Create user ' mdev ' @ ' localhost ' identified by ' mdev4admin ';
Grant Shutdown on *. * to ' mdev ' @ ' localhost ';
Luckily, Mysqld_multi is a Perl script that is easy to find for reasons, and is interested in referencing the documentation that follows.
Treatment methods:
- Modify the Mysqld_mutli
my $com= join ‘ ‘, ‘my_print_defaults ‘, @defaults_options, $group;
To be replaced by:
my $com= join ‘ ‘, ‘my_print_defaults -s‘, @defaults_options, $group;
- Call Mysqld_multi incoming password
mysqld_multi stop 3307 --password=mdev4admin
Source: Http://wubx.net/mysqld_multi-stop-mysqld-not-working/?utm_source=tuicool&utm_medium=referral
Mysqld_multi can't close MySQL processing tips