Bug #28479 --skip-password causes problems for mysqlbinlog

• Submitted: 16 May 2007 19:26
• Modified: 18 Jun 2009 14:59
• Reporter: Tobias Asplund
• Status: Closed
• 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

[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:[e-mail]-20090528073639-yohsb4q1jzg7ycws) (version source revid:[e-mail]-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:[e-mail]-20090616183122-chjzbaa30qopdra9) (version source revid:[e-mail]-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:[e-mail]-20090826132541-yablppc59e3yb54l) (version source revid:[e-mail]-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:[e-mail]-20090826105955-bkj027t47gfbamnc) (version source revid:[e-mail]-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:[e-mail]-20090825194404-37rtosk049t9koc4) (version source revid:[e-mail]-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:[e-mail]-20090827163030-6o3kk6r2oua159hr) (version source revid:[e-mail]-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.