MySQL Forums
Forum List  »  Newbie

passord problems
Posted by: John Martinson
Date: June 27, 2005 08:08AM

I am running mysql 4.0.42-nt on a windows 2000

I am trying to set up a mysql database and was testing out the password feature and when I set up a new accont for a password and then try to log on using that password it never works. When I try to log on using the new user and no password it will log on. Is there something that I am missing here?

I have tried the SET PASSWORD FOR 'newuser@localhost' = PASSWORD('a');
to set a simple passoword.
When I SELECT password FROM user WHERE user = 'java@localhost' it returns what appears to be a hash. That is good I think, but why won't it let me log in? I've looked in the help files and have gotten nowhere.

loneProgrammer

Options: ReplyQuote


Subject
Written By
Posted
passord problems
June 27, 2005 08:08AM
June 27, 2005 12:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.