错误:mysqladmin:刷新失败；错误:“未知错误" [英] Error: mysqladmin: refresh failed; error: 'Unknown error'
问题描述
我的问题开始于我每天都疲倦于从Cron Daemon收到电子邮件时.电子邮件看起来像这样:
My problem started when I was tired to get emails every day from Cron Daemon. The emails look like this:
From: Cron Daemon <root@xxx.xxx>
Date: 2014-08-25 6:29 GMT+03:00
Subject: Cron <root@xxx> test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
To: root@xxx.xxx
/etc/cron.daily/logrotate:
/usr/bin/mysqladmin: refresh failed; error: 'Unknown error'
error: error running shared postrotate script for '/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log /var/log/mysql/error.log '
run-parts: /etc/cron.daily/logrotate exited with return code 1
我的收件箱中有40封这样的电子邮件.我发现一种方法是说问题出在以下事实，即密码debian.cnf没有与另一个密码对应.因此，我在mysql控制台中将其分类:
I have 40 emails like this in my inbox. A method that I found it's said that the problem comes from the fact that password debian.cnf not corspunde with another password. So I tride this in mysql console:
GRANT RELOAD, SHUTDOWN, PROCESS, SHOW DATABASES, SUPER, LOCK TABLES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'XXXXXXXX’;flush-privileges;
此后，我做了检查:
$ mysqladmin --defaults-file=/etc/mysql/debian.cnf ping
结果:
mysqld is alive
好的，但是电子邮件stil并没有停止.所以当我跑步时:
Ok, but the emails stil not stoped. So when I run:
$ mysqladmin -u root -p flush-log
结果:
mysqladmin: refresh failed; error: 'Unknown error'
那么，我该如何调试这个想法?
So, how can I debug this, any ideas?
更新:根据我的阅读，这是一个错误.我建议放手，对mysql-server和mysql-client进行更新.干杯！
UPDATE: This is a bug, from what I read. I suggest to let it go and make an update to mysql-server and mysql-client. Cheers!
$ sudo apt-get install mysql-server-5.6 mysql-client-5.6
推荐答案
我有相同的错误.解决方案是修复日志目录&的权限.文件:
I had the same error. The solution was to fix permissions of log directory & files:
sudo chown -Rv mysql /var/log/mysql
更新/重新安装对您有所帮助，可能是因为mysql安装脚本为您修复了权限.
The update/reinstall helped you probably because the mysql install script fixed the permissions for you.
这篇关于错误:mysqladmin:刷新失败；错误:“未知错误"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
