MySQL多实例使用mysqld_multi stop 无法关闭数据库
---------------------- /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'
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 |
处理方法
|
1
2
3 |
# which mysqld_multi/usr/bin/mysqld_multi# vi /usr/bin/mysqld_multi |
|
1
2
3 |
my $com=
join
' '
,
'my_print_defaults '
, @defaults_options, $group; 替换为： my $com=
join
' '
,
'my_print_defaults -s'
, @defaults_options, $group;
|
About Me
|
........................................................................................................................ ● 本文作者：小麦苗，部分内容整理自网络，若有侵权请联系小麦苗删除 ● 本文在itpub、博客园、CSDN和个人微 信公众号（ DB宝）上有同步更新 ● 本文itpub地址： http://blog.itpub.net/26736162 ● 本文博客园地址： http://www.cnblogs.com/lhrbest ● 本文CSDN地址： https://blog.csdn.net/lihuarongaini ● 本文pdf版、个人简介及小麦苗云盘地址： http://blog.itpub.net/26736162/viewspace-1624453/ ● 数据库笔试面试题库及解答： http://blog.itpub.net/26736162/viewspace-2134706/ ● DBA宝典今日头条号地址： http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826 ........................................................................................................................ ● QQ群号： 230161599 、618766405 ● 微 信群：可加我微 信，我拉大家进群，非诚勿扰 ● 联系我请加QQ好友 （ 646634621 ），注明添加缘由 ● 于 2020-05-01 06:00 ~ 2020-05-30 24:00 在西安完成 ● 最新修改时间：2020-05-01 06:00 ~ 2020-05-30 24:00 ● 文章内容来源于小麦苗的学习笔记，部分整理自网络，若有侵权或不当之处还请谅解 ● 版权所有，欢迎分享本文，转载请保留出处 ........................................................................................................................ ● 小麦苗的微店： https://weidian.com/s/793741433?wfr=c&ifr=shopdetail ● 小麦苗出版的数据库类丛书： http://blog.itpub.net/26736162/viewspace-2142121/ ● 小麦苗OCP、OCM、高可用网络班： http://blog.itpub.net/26736162/viewspace-2148098/ ● 小麦苗腾讯课堂主页： https://lhr.ke.qq.com/ ........................................................................................................................ 使用 微 信客户端扫描下面的二维码来关注小麦苗的微 信公众号（ DB宝）及QQ群（DBA宝典）、添加小麦苗微 信， 学习最实用的数据库技术。
........................................................................................................................ |
 |
|