mysql syntax fail

| No Comments | No TrackBacks
I've always found it hard to remember some aspects of mysql syntax regarding users and accounts. I think I know why now.

If you want to create a user, you can do:

CREATE USER 'bob'@'localhost' IDENTIFIED BY 'mypass';

If you don't want to use their plain text password here, you can specify the hash value, but so that mysql doesn't get confused you have to add the PASSWORD keyword. So that would look like:
CREATE USER 'bob'@'localhost' IDENTIFIED BY PASSWORD '*90E462C37378CED12064BB3388827D2BA3A9B689';

So... to specify the hash of their password, you have to add the PASSWORD keyword. Honestly, how does that make sense?

No TrackBacks

TrackBack URL:

Leave a comment