1. If you can view "blahblah;;" in the password field of the user table, then the
password wasn't encoded in the
first place. That leads one to conclude the change was accomplished using UPDATE and
the field was set to
"blahblah;;" and not to PASSWORD('blahblah;;'). What mysql stores in the password
field is the
encrypted PW which would not be recognizeable as the original that you need to use to
log in.
2. Using the proper GRANT or UPDATE syntax, it is possible to set up a user with
semi-colons (;) in the password. I
tested with and without escaping the semi-colon, and it works either way.
3. For all other details, rtfm.
Doug
On Fri, 15 Mar 2002 14:47:03 -0500, adam nelson wrote:
>I don't see how to submit 'blahblah;;' using the quotes.
>
>I've tried
>
>mysql -u root
>
>and then typed all the conceivable combinations for password
>
>and
>
>mysql -u root --password=blahblah;;
>
>and
>
>mysql -u root --password='blahblah;;'
>
>What's worse is that I've looked at the raw table file and confirmed
>that the password is blahblah;;
>
>I could change it manually, but I don't want to corrupt the table (I
>assume that's a real possibility). -- tried that on a dev machine, it
>doesn't work because I can't flush the privileges.
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
