十.mysqld_multi stop无效问题
2024-08-25 06:34:26
今天在尝试运行mysqld_report stop的时候，发现无法停止mysql，日志中的错误如下
Stopping MySQL servers mysqladmin: [Warning] Using a password on the command line interface can be insecure.
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
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: Tue Jan ::
可以看出，肯定是使用mysqladmin无法登录的问题。
但是，我的my.cnf配置文件中，已经指定了user和password，整个文件内容如下
[client]
port=
socket=/tmp/mysql.sock [mysqld_multi]
user=root
password=root
mysqld=/usr/local/mysql/bin/mysqld_safe
mysqladmin=/usr/local/mysql/bin/mysqladmin
log=/home/mysql/mysqld_multi.log [mysqld]
basedir=/usr/local/mysql
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysqld3306]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/home/mysql/mysql3306/data
port=
server_id=
socket=/tmp/mysql3306.sock
log-output=file
slow_query_log =
long_query_time =
slow_query_log_file = /home/mysql/mysql3306/log/slow.log
log-error = /home/mysql/mysql3306/log/error.log
binlog_format = mixed
log-bin = /home/mysql/mysql3306/log/mysql3306_bin [mysqld3307]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/home/mysql/mysql3307/data
port=
server_id=
socket=/tmp/mysql3307.sock
log-output=file
slow_query_log =
long_query_time =
slow_query_log_file = /home/mysql/mysql3307/log/slow.log
log-error = /home/mysql/mysql3307/log/error.log
binlog_format = mixed
log-bin = /home/mysql/mysql3307/log/mysql3307_bin [mysqld3308]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/home/mysql/mysql3308/data
port=
server_id=
socket=/tmp/mysql3308.sock
log-output=file
slow_query_log =
long_query_time =
slow_query_log_file = /home/mysql/mysql3308/log/slow.log
log-error = /home/mysql/mysql3308/log/error.log
binlog_format = mixed
log-bin = /home/mysql/mysql3308/log/mysql3308_bin
其实，此时的配置有问题不对“password=root”应该改为“pass=root”,文件如下
[client]
port=
socket=/tmp/mysql.sock [mysqld_multi]
user=root
pass=root
mysqld=/usr/local/mysql/bin/mysqld_safe
mysqladmin=/usr/local/mysql/bin/mysqladmin
log=/home/mysql/mysqld_multi.log [mysqld]
basedir=/usr/local/mysql
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysqld3306]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/home/mysql/mysql3306/data
port=
server_id=
socket=/tmp/mysql3306.sock
log-output=file
slow_query_log =
long_query_time =
slow_query_log_file = /home/mysql/mysql3306/log/slow.log
log-error = /home/mysql/mysql3306/log/error.log
binlog_format = mixed
log-bin = /home/mysql/mysql3306/log/mysql3306_bin [mysqld3307]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/home/mysql/mysql3307/data
port=
server_id=
socket=/tmp/mysql3307.sock
log-output=file
slow_query_log =
long_query_time =
slow_query_log_file = /home/mysql/mysql3307/log/slow.log
log-error = /home/mysql/mysql3307/log/error.log
binlog_format = mixed
log-bin = /home/mysql/mysql3307/log/mysql3307_bin [mysqld3308]
mysqld=mysqld
mysqladmin=mysqladmin
datadir=/home/mysql/mysql3308/data
port=
server_id=
socket=/tmp/mysql3308.sock
log-output=file
slow_query_log =
long_query_time =
slow_query_log_file = /home/mysql/mysql3308/log/slow.log
log-error = /home/mysql/mysql3308/log/error.log
binlog_format = mixed
log-bin = /home/mysql/mysql3308/log/mysql3308_bin
最新文章
- django _meta方法
- Hibernate连接数据库超时设置autoReconnect=true
- cache与MMU与总线仲裁
- hdu----(2222)Keywords Search(trie树)
- <<操作系统精髓与设计原理>>读书笔记(一) 并发性:互斥与同步（1）
- pandas数据结构之series操作
- C#通过COM组件调用IDL的pro程序
- C#基础知识之泛型集合转换为DataTable
- 爬虫_电影天堂 热映电影（xpath）
- MongoDB 查询总结
- 让你的app体验更丝滑的11种方法！冲击手机应用榜单Top3指日可待
- 【Android】2.0 第2章 初识Android App
- Golang 新手可能会踩的 50 个坑
- Golden Tiger Claw UVA - 11383（km原理）
- dorado7常用内容
- 不能修改列 "。。"，因为它是计算列，或者是 UNION 运算符的结果。
- Redhat5.9安装qt5.5.1出错error while loading shared libraries:libX11-cxb.so.1 标签： qt5 2017-06-02 11
- usebean 使用语法
- 关于SQL注入的五大报错注入函数
- Nginx-安装依赖及配置详解