3 messages in com.mysql.lists.bugsFwd: root password bug...?
FromSent OnAttachments
Rescue12 Aug 2001 18:34 
Rescue12 Aug 2001 20:06 
Michael Widenius13 Aug 2001 00:46 
Subject:Fwd: root password bug...?
From:Michael Widenius (mon@mysql.com)
Date:08/13/2001 12:46:31 AM
List:com.mysql.lists.bugs

Note that the bu@lists.mysql.com mailing list is only meant for repeatable bugs report with full examples. We at MySQL AB will ensure that all bug reports of this type are promptly answered and all bugs are fixed or documented (if the final fix has to be delayed to a future MySQL version because of design problems). Please post normal other reports to the mys@lists.mysql.com list or to the appropriate mailing list.

"Rescue" == Rescue <resc@yahoo.com> writes:

Rescue> I believe the previous submission might have been in Rescue> error. I now believe that either the bug is that you Rescue> can't use any non-alphanumeric characters in your root Rescue> password, or that the system was designed this way. In Rescue> witch it needs to be changed. non-alphanumeric Rescue> characters increase the security factor.

MySQL itself doesn't have any problems with handling '$' in the password. I think the problem you got has to do with that your shell parses the '$' character.

Here is what I tried that worked without any problems for me:

mysqladmin -utest --password='$qq' mysqladmin -utest --password='$qq' ver

Regards, Monty