On Wed, Apr 22, 2009 at 3:04 PM, Carlos Williams <[email protected]> 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/[email protected]
