adam,
Friday, March 15, 2002, 9:47:03 PM, you wrote:
an I don't see how to submit 'blahblah;;' using the quotes.
an I've tried
an mysql -u root
an and then typed all the conceivable combinations for password
an and
an mysql -u root --password=blahblah;;
an and
an mysql -u root
I just had the brilliant idea of using a password for mysql root with
semi-colons:
password is blahblah;;
this appears to have not worked in some way and now I'm stuck. I don't
want to restart since that isn't very graceful (on a production
machine). I've tried blahblah;;; and blahblah and
with the client?
-Original Message-
From: adam nelson [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 15, 2002 12:37 PM
To: [EMAIL PROTECTED]
Subject: password special character muck up (I think)
I just had the brilliant idea of using a password for mysql root with
semi-colons:
password
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
I can access the client using other users, but none have mysql database
access (ie. everything is fine except that I can't add users). If
nobody knows the answer, I will restart with skip-grant-tables during
off-hours.
-
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