Bug #68973 mysqldump: unknown option '--skip-secure-auth'

• Submitted: 16 Apr 2013 14:40
• Modified: 7 Jul 2014 18:04
• Reporter: martin fuxa
• Status: Unsupported
• Category: MySQL Server: Backup
• Severity: S2 (Serious)
• Version: 5.6.10
• OS: Any
• CPU Architecture: Any

[16 Apr 2013 14:40] martin fuxa

Description:
mysql client is able to connect to Mysql 4.0 server (in my case 4.0.27-log). But mysqldump isn't!

mysql --version
mysql  Ver 14.14 Distrib 5.6.10, for Linux (i686) using  EditLine wrapper

mysqldump --version
mysqldump  Ver 10.13 Distrib 5.6.10, for Linux (i686)

How to repeat:
mysql -h mysql40-server --skip-secure-auth
works ok

mysqldump -h mysql40.unihost.cz -B mysql --secure_auth=0
mysqldump: unknown variable 'secure_auth=0'
fail!

mysqldump -h mysql40.unihost.cz -B mysql --skip-secure-auth
mysqldump: unknown option '--skip-secure-auth'
fail!

mysqldump -h mysql40.unihost.cz -B mysql --compatible=mysql40
mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled) when trying to connect
fail!

Suggested fix:
implement skip-secure-auth to mysqldump. as well as is in mysql.

[16 Apr 2013 16:03] Sveta Smirnova

Thank you for the report.

Version 4.0 is not supported, so I am closing this as "Unsupported". Earliest supported version is 5.0 See http://www.mysql.com/support/supportedplatforms/database.html for details.

[7 Jul 2014 18:04] martin fuxa

with mysqldump  Ver 10.13 Distrib 5.6.17, for Linux (i686) works fine, yet!

for example
mysqldump -h mysql40.unihost.cz --skip-secure-auth -y -B -R -E --lock-tables=0 mysql