MySQL Forums
Forum List  »  Newbie

Re: passord problems
Posted by: John Martinson
Date: June 27, 2005 12:07PM

I figured out my own problem. I did not properly distinguish the host when using the GRANT function. This caused some confusion on the part of MYSQL and things were not getting parsed right.

For someone havinhg similar problems I would recomend using the following query from the root user

use mysql;
SELECT user, host, password FROM user;

This will give the username, host and password for each user. The Combination of user and host needs to match inorder for the password to work, if not it won't work. Or at least that is what I have been able to learn in my first day using mySql.

Options: ReplyQuote


Subject
Written By
Posted
June 27, 2005 08:08AM
Re: passord problems
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.