setting users and passwords

[jacksplat]

i'm following some isntructions online and it told me to assign a username and a password to access a database i created by using the line:

GRANT ALL ON database.* TO user IDENTIFIED BY 'password';

at the mysql prompt. when i do this, i get this when i hit enter "Query OK, 0 rows affected (0.00 sec)"

and when i try to access my database using a php login script, it says that my password is wrong. i don't know what i am doing wrong. please help. i'm on freebsd 4.5 if thats any help.

 

[jacksplat]

and actually, i just tried that line using a username other than "admin" as i had tried before. when i use "admin" it says "incorrect password." when i use another user name, it says "the user name you supplied is not valid"

 

[jacksplat]

ok sorry, i figured it out, i had to use a username and password they gave me on another page that i forgot about...thanks anyway