Apache Friends Support Forum

I cannot seem to figure out how to set an existing user to a new database. I wouldn't think I would have to create a new user to put with a new database would I?

Thanks

GRANT ALL PRIVILEGES ON `somedb`.* TO 'someuser'@'somehost' WITH GRANT OPTION ;

(see http://dev.mysql.com/doc/refman/5.0/en/grant.html )

cheers

ok I went in to user overview and selected the grant box and it added that user to global and to my new database. Thanks a bunch!!

BobbyS wrote:ok I went in to user overview and selected the grant box and it added that user to global and to my new database. Thanks a bunch!!

Not a good idea to give any single user, other than the super user root, global privileges.

This database user should have privileges for the database you set only - best practices learned now will be of benefit regarding security in the future.

Thanks Izzy. I got to thinking and came up with the same conclusion.