Mysql Password Problem
 

I'm trying to give my users who have access to my mysql database a password so that they require a password when connecting.

I've updated the password field in the table user in the mysql database using the password function to encrypt it but MYSQL doesn't seem to want to accept the password.

I'm using MYSQL-Front on a Windows 2000 Machine to connect to the MYSQL Server.

If I enter a password It cannot connect to the database but If I enter just a username I can connect without any problems.

Is there something I need to set to force MYSQL to accept Passwords.

Hope someone can help this is driving me round in circles

Thanks
Flossie:study:

Have you tried to simply connect as the root user thru the command line or the such and attempt to update mysql by adding a user that way with a password? It sounds to me like its a problem with whatever front end GUI your using.

Just a quick question.


After Changing the password do you need to do a Flush Priviliges before the password is activiated.

Did MySQL/PHP come embedded or did you install? I think theres an issue using md5 encryption if MySQL/PHP came embedded. not sure on this maybe someone can shed some light?

No I downloaded MYSQL from www.mysql.com and installed it myself.

For a user to connect from somewhere other than the localhost they have to be created as

mysql> GRANT "whatever privileges" ON *.* TO user@"%"
-> IDENTIFIED BY 'some_password' ;
mysql> FLUSH PRIVILEGES;

check out the manual, excellent document.

http://dev.mysql.com/doc/

Bob

I'll give that I try

Thanks for all your help. Don't know where I would be without these forums

Thanks again