Bug #65168 Workbench Utilities cannot handle strong passwords
Submitted: 1 May 2012 18:48 Modified: 3 May 2013 6:50
Reporter: Van Stokes Email Updates:
Status: Closed Impact on me:
Category:MySQL Utilities Severity:S3 (Non-critical)
Version:5.2.39 OS:Linux (Ubuntu 11.10 x86_64)
Assigned to: CPU Architecture:Any
Tags: password, strong, utilities, utility, workbench

[1 May 2012 18:48] Van Stokes
MySQL Server: 5.5.22 x64 on Ubuntu Linux 11.10 x64

When using strong passwords the utilities cannot connect to MySQL server.

Example strong password: r/^ak#>0,Xl-7H4

Failed command:

./mysqldiff --difftype=sql --force --quiet --changes-for=server2 '--server1=myuser:r/^ak#>0,Xl-7H4@localhost' oti_elite_import.lapcost:oti_elite_test.lapcost
ERROR: Cannot connect to the server1 server.
Error 1045: Access denied for user 'edi'@'' (using password: YES)

However, this works:

mysql --host=localhost --user=myuser --password="r/^ak#>0,Xl-7H4"

How to repeat:
Create a user using the strong password above and then try to use the WB utilities.

Suggested fix:
Support strong passwords in the utilities.
[26 Jul 2012 20:25] Sveta Smirnova
Thank you for the report.

Verified as described.
[26 Apr 2013 20:58] Chuck Bell
Fixed in release-1.2.2.
[3 May 2013 6:50] Philip Olson
This bug was fixed previously via MySQL Bug #67480, and here was the changelog entry:

Fixed as of the upcoming MySQL Utilities 1.2.2 release, and here's the
changelog entry:

Connection strings would not accept usernames or passwords that contained
a hyphen ("-"). Using single or double quotes is now supported. For
example, passing in --server="user:'pass@:-chars'@localhost" as a connection
string to a MySQL Utility is now valid.

Thank you for the bug report.