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