creating users

[Anon]

I am having a problem creating users in mysql. I have done what the manual suggests and am able to connect to mysql
but I am not able to create databases or use current databases.

Please help

Thanks

[Anon]

After you've created the user, did you remeber to grant permissions for that user? If so, did you remeber to do 'mysqladmin reload' so the permissions take effect?

Aaron

[Anon]

What permissions should I give ?

Thanks again,

Neville.

[Anon]

You probably want select, insert, update, and delete so do something like:

grant select, insert. update, delete on somedb.* to someuser@localhost identified by 'somepassword';

Then make sure you reload the grant tables:
mysqladmin reload

Aaron

[Anon]

Ok ..... I'll try that ...thanks

[Anon]

You can use

flush privileges;

at the mysql prompt, instead of going out and doing a reload, too.

---John Holmes...