Package: mysql-server-5.6 Version: 5.6.27-2 Severity: normal Dear Maintainer,
After upgraded from mysql-server 5.5 to 5.6, I'm facing problem below use: root@server~# mysqladmin --defaults-file=/etc/mysql/debian.cnf flush-logs mysqladmin: refresh failed; error: 'Access denied; you need (at least one of) the RELOAD privilege(s) for this operation' root@server~# But I can use mysqladmin command as below: root@server~# mysqladmin -udebian-sys-maint -p flush-logs Enter password: root@server~# and it works. Password used, it just a copy/paste of the password found in /etc/mysql/debian.cnf I've also tried with /root/.my.cnf file and removed --defaults-file=/etc/mysql/debian.cnf from the command line, I get the same problem. Same, remove privileges to user debian-sys-maint in mysql and re-grant didn't change anything. -- System Information: Debian Release: stretch/sid APT prefers testing APT policy: (500, 'testing') Architecture: amd64 (x86_64) Kernel: Linux 4.2.0-1-amd64 (SMP w/2 CPU cores) Locale: LANG=en_GB, LC_CTYPE=en_GB (charmap=locale: Cannot set LC_ALL to default locale: No such file or directory ISO-8859-1) Shell: /bin/sh linked to /bin/dash Init: sysvinit (via /sbin/init) Versions of packages mysql-server-5.6 depends on: ii adduser 3.113+nmu3 ii debconf [debconf-2.0] 1.5.58 ii init-system-helpers 1.24 ii initscripts 2.88dsf-59.2 ii libaio1 0.3.110-2 ii libc6 2.19-22 ii libdbi-perl 1.634-1 ii libgcc1 1:5.2.1-23 ii libstdc++6 5.2.1-23 ii libwrap0 7.6.q-25 ii lsb-base 9.20150917 ii mysql-client-5.6 5.6.27-2 ii mysql-common 5.6.27-2 ii mysql-server-core-5.6 5.6.27-2 ii passwd 1:4.2-3.1 ii perl 5.20.2-6 ii psmisc 22.21-2.1 ii zlib1g 1:1.2.8.dfsg-2+b1 Versions of packages mysql-server-5.6 recommends: ii libhtml-template-perl 2.95-2 Versions of packages mysql-server-5.6 suggests: ii heirloom-mailx [mailx] 12.5-5 pn tinyca <none> -- Configuration Files: /etc/logrotate.d/mysql-server changed: /var/log/mysql/*log { daily rotate 7 missingok notifempty size 1 create 640 mysql adm compress sharedscripts postrotate test -x /usr/bin/mysqladmin || exit 0 # If this fails, check debian.conf! MYADMIN="/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf" if [ -z "`$MYADMIN ping 2>/dev/null`" ]; then # Really no mysqld or rather a missing debian-sys-maint user? # If this occurs and is not a error please report a bug. #if ps cax | grep -q mysqld; then if killall -q -s0 -umysql mysqld; then exit 1 fi else $MYADMIN flush-logs fi endscript } /etc/mysql/mysql.conf.d/mysqld.cnf changed: [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking bind-address = 127.0.0.1 key_buffer_size = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M general_log_file = /var/log/mysql/mysql.log general_log = 0 log_error = /var/log/mysql/error.log slow_query_log_file = /var/log/mysql/mysql-slow.log slow_query_log = 1 long_query_time = 5 log-queries-not-using-indexes expire_logs_days = 10 max_binlog_size = 100M -- debconf information: mysql-server-5.6/really_downgrade: false mysql-server/no_upgrade_when_using_ndb: mysql-server-5.6/postrm_remove_databases: false mysql-server/password_mismatch: mysql-server-5.6/nis_warning: mysql-server-5.6/start_on_boot: true mysql-server/error_setting_password: