On Wed, Apr 22, 2009 at 3:11 PM, Carlos Williams <carlosw...@gmail.com> wrote: > On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams <carlosw...@gmail.com> wrote: >> Now I did create that new database called 'forums' and would like to >> create a new user who has access only to that specific database from >> localhost. I can't seem to find the command via Google on how I create >> the user and grant access to just that one specific 'forums' database. > > Is this correct assuming I already created the 'forums' database? > > mysql> CREATE USER 'carlos'@'localhost' IDENTIFIED BY 'p...@$$w3rd'; > mysql> GRANT ALL PRIVILEGES ON forums.* TO 'carlos'@'localhost' > -> WITH GRANT OPTION; > > I don't know if the above is correct way to create a new user in MySQL > and grant privileges > only to access the 'forums' database. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=george.g.lar...@gmail.com > >
I've got one foot out the door, so I'm just going to shoot some links for now: http://dev.mysql.com/doc/refman/5.1/en/create-user.html http://www.databasef1.com/tutorial/mysql-create-user.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org