tags 408452 -moreinfo -unreproducable thanks Hi,
I can also confirm the problem on sid & lenny, and the way to reproduce & solve it as outlined at: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=408452#34. Just one clarification, this problem exists only if /root/.my.cnf contain: [client] password=xxxxxxx but do not contain user=xxxx if user=xxxx is also defined, then the command sent to mysqladmin is: mysqladmin --port=3306 --socket=/var/run/mysqld/mysqld.sock --host=localhost --user=debian-sys-maint --password=xxxxxxx --socket=/var/run/mysqld/mysqld.sock --user=root --password=yyyyyyy extended-status Which basically provides mysqladmin with 2 sets of user/password, and mysqladmin takes the last set of user/password from the command line. The problem occurs when: user=xxxx is not specified in /root/.my.cnf, then the command looks like this: mysqladmin --port=3306 --socket=/var/run/mysqld/mysqld.sock --host=localhost --user=debian-sys-maint --password=xxxxxxx --socket=/var/run/mysqld/mysqld.sock --password=yyyyyyy extended-status Causing mysqladmin to effectively use: user=debian-sys-maint and password=yyyyyyy (roots mysql password). Obviously this is not what we want, and setting --defaults-file=/etc/mysql/debian.cnf will make this unambiguous, and will only take the options from /etc/mysql/debian.cnf. Regards, Tom Feiner
signature.asc
Description: OpenPGP digital signature
