MySQL people, need you help.

[notfred]

I need to create a user that has access to do anything he wants to a specific database, and has no priveledges at all on any other database. Can someone help me set this up?

 

[yllus]

Oh, no problem. Just specifically mention the database name in your GRANT statements.

GRANT <privilege> ON databasename.* TO <username>;

 

[notfred]

k, seems to be working now. Setting up this server has been such a bitch... they should jsut say "you need to have the development libraries installed if you want to compile this" for some things...