Results 1 to 1 of 1
Apr 20, 2004, 15:04 #1
- Join Date
- Mar 2004
- united states
- 0 Post(s)
- 0 Thread(s)
how to grants privileges to a user?
I am experimenting with creating new users, granting them privileges and revoking them.
Here is what I am trying to do:
create a new user account for a user with username: 'johnsmith' and password: 'johnpassword'.
Allow that user to right to perform the following commands on database 'dbname': select, update, insert
After reading the manual, here is what I tried:
grant select, update, insert on dbname.* to 'johnsmith' identified by password 'johnpassword';
this didn't work because I got an error saying that:
"Password hash should be a 41-digit hexadecimal number"
could someone show me how I can create a new user account and provide that use with the privileges to select, update, insert?
thanks in advance