MySQL多实例使用mysqld_multi stop 无法关闭数据库
Tags： MySQLmysqld_multi
👉 本文共约82个字，系统预计阅读时间或需1分钟。
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 | ---------------------- /etc/my.cnf 管理多实例 [mysqld_multi] mysqld=/usr/local/mysql80/mysql8016/bin/mysqld_safe mysqladmin=/usr/local/mysql80/mysql8016/bin/mysqladmin log=/usr/local/mysqlsoft/log/mysqld_multi.log user=root password=lhr #[client] #user=root #host=localhost #password=lhr [mysql] default-character-set=utf8mb4 [mysqld55573320] mysqld=/usr/local/mysql55/mysql5557/bin/mysqld_safe mysqladmin=/usr/local/mysql55/mysql5557/bin/mysqladmin port=3320 basedir=/usr/local/mysql55/mysql5557 datadir=/usr/local/mysql55/mysql5557/data socket=/usr/local/mysql55/mysql5557/data/mysqls55573320.sock server_id=55573320 log-bin [mysqld56373330] mysqld=/usr/local/mysql56/mysql5637/bin/mysqld_safe mysqladmin=/usr/local/mysql56/mysql5637/bin/mysqladmin port=3330 basedir=/usr/local/mysql56/mysql5637 datadir=/usr/local/mysql56/mysql5637/data socket=/usr/local/mysql56/mysql5637/data/mysqls56373330.sock server_id=56373330 log-bin slow_query_log=1 slow_query_log_file=/usr/local/mysql56/mysql5637/data/mysqld56373330-slow.log [mysqld57193340] mysqld=/usr/local/mysql57/mysql5719/bin/mysqld_safe mysqladmin=/usr/local/mysql57/mysql5719/bin/mysqladmin port=3340 basedir=/usr/local/mysql57/mysql5719 datadir=/usr/local/mysql57/mysql5719/data socket=/usr/local/mysql57/mysql5719/data/mysqls57193340.sock server_id=57193340 log-bin [mysqld80163350] mysqld=/usr/local/mysql80/mysql8016/bin/mysqld_safe mysqladmin=/usr/local/mysql80/mysql8016/bin/mysqladmin port=3350 basedir=/usr/local/mysql80/mysql8016 datadir=/usr/local/mysql80/mysql8016/data socket=/usr/local/mysql80/mysql8016/data/mysqls80163350.sock default_authentication_plugin=mysql_native_password server_id=80163350 log-bin |
在执行关闭数据库的时候，用户、密码、权限检查后都是OK的。
1 2 3 4 | Warning: Using a password on the command line interface can be insecure. /usr/bin/mysqladmin : connect to server at 'localhost' failed error: 'Access denied for user ' root '@' localhost ' (using password: YES)' mysqld_multi log file version 2.16; run: Wed Dec 14 15:31:32 2016 |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
处理方法
1 2 3 4 5 6 7 8 9 | # which mysqld_multi /usr/bin/mysqld_multi # vi /usr/bin/mysqld_multi my $com= join ' ' , 'my_print_defaults ' , @defaults_options, $group; 替换为： my $com= join ' ' , 'my_print_defaults -s' , @defaults_options, $group; |
