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

• Submitted: 16 May 2007 21:26
• Modified: 18 Jun 16:59
• Reporter: Tobias Asplund
• Status: Closed
• Category: Client
• Severity: S3 (Non-critical)
• Version: 5.0.37, 5.1.17, 4.1
• OS: Any
• Assigned to: Jim Winstead
• Target Version: 6.0
• Triage: Triaged: D2 (Serious)

[16 May 2007 21: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

[17 May 2007 0:13] Sveta Smirnova

Thank you for the report.

Verified as described.

On Linux both mysqlbinlog and mysqldump are affected.

[20 Feb 2008 20:57] Omer BarNir

workaround: Use a user that has a password

[7 May 19: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 18:08] Jim Winstead

Patch queued to 5.1-bugteam, will be merged up from there.

[28 May 10: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 4: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 21: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 16:59] Paul DuBois

Noted in 5.4.4 changelog.

[13 Aug 1: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 4:18] Paul DuBois

Ignore previous comment about 5.4.2.

[26 Aug 15: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 15: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 15: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 18: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 3:29] Paul DuBois

The 5.4 fix has been pushed to 5.4.2.