Bug #28479 --skip-password causes problems for mysqlbinlog
Submitted: 16 May 2007 19:26 Modified: 18 Jun 2009 14:59
Reporter: Tobias Asplund Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.37, 5.1.17, 4.1 OS:Any
Assigned to: Jim Winstead CPU Architecture:Any
Triage: Triaged: D2 (Serious)

[16 May 2007 19:26] Tobias Asplund
Description:
imagine a setup where you have a my.cnf:

[client]
password

on windows the console can now not handle a command like:
mysqlbinlog ... | mysql
since it'll ask for the password twice, the windows console can't
handle it.

so, adding
[mysqlbinlog]
skip-password

would help that situation, unfortunately that seems to not really work!

How to repeat:
On MAC:

flupps@flupps-computer:~$ mysqlbinlog --skip-password
Enter password: 
Bus error
flupps@flupps-computer:~$ mysqldump --skip-password
Bus error
flupps@flupps-computer:~$ mysql --skip-password
(no problem for mysql)

On Linux:
flupps@piglet:~$ mysqlbinlog --skip-password
Segmentation fault

Suggested fix:
Make --skip-password work for mysqlbinlog/mysqldump just like it does for mysql
[16 May 2007 22:13] Sveta Smirnova
Thank you for the report.

Verified as described.

On Linux both mysqlbinlog and mysqldump are affected.
[20 Feb 2008 19:57] Omer Barnir
workaround: Use a user that has a password
[7 May 2009 17:53] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/73602

2888 Jim Winstead	2009-05-07
      Various command-line utilities, including mysqlbinlog and mysqldump, don't
      handle the --skip-password option correctly. (Bug #28479)
      modified:
        client/mysql_upgrade.c
        client/mysqladmin.cc
        client/mysqlbinlog.cc
        client/mysqlcheck.c
        client/mysqldump.c
        client/mysqlimport.c
        client/mysqlshow.c
        client/mysqlslap.c
        client/mysqltest.cc
[13 May 2009 16:08] Jim Winstead
Patch queued to 5.1-bugteam, will be merged up from there.
[28 May 2009 8:19] Bugs System
Pushed into 5.1.36 (revid:joro@sun.com-20090528073639-yohsb4q1jzg7ycws) (version source revid:jimw@mysql.com-20090512212719-mjc8fz4q3ewvr4yd) (merge vers: 5.1.35) (pib:6)
[30 May 2009 2:17] Paul Dubois
Noted in 5.1.36 changelog.

Several client programs failed to interpret --skip-password as "send
no password." 

Setting report to NDI pending push into 6.0.x.
[17 Jun 2009 19:21] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090616183122-chjzbaa30qopdra9) (version source revid:jimw@mysql.com-20090514020104-7u5cqf5cyywa8aks) (merge vers: 6.0.12-alpha) (pib:11)
[18 Jun 2009 14:59] Paul Dubois
Noted in 5.4.4 changelog.
[12 Aug 2009 23:01] Paul Dubois
Noted in 5.4.2 changelog because next 5.4 version will be 5.4.2 and not 5.4.4.
[15 Aug 2009 2:18] Paul Dubois
Ignore previous comment about 5.4.2.
[26 Aug 2009 13:45] Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48] Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:32] Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[9 Oct 2009 1:29] Paul Dubois
The 5.4 fix has been pushed to 5.4.2.