John,
Thursday, October 31, 2002, 11:49:08 PM, you wrote:
JM> How do I create users for a specific database using SQL?
Take a look at GRANT statement:
http://www.mysql.com/doc/en/GRANT.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsore
> Create the record for the user in the user table (do not forget to do
> password=PASSWORD('pastext'))
> Then insert a record in the db table with the db name you want them to
> access and the options.
Or you could use:
GRANT SELECT, UPDATE, INSERT, DELETE ON somedb.* TO someuser@localhost
IDENT
Create the record for the user in the user table (do not forget to do
password=PASSWORD('pastext'))
Then insert a record in the db table with the db name you want them to
access and the options.
HTH.
JFernand
** sql **
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com
It's all right here => http://www.mysql.com/manual.php
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com]
Sent: Thursday, October 31, 2002 1:49 PM
To: [EMAIL PROTECTED]
Subject: Creating users through SQL
How do I create users for a specific database using SQL?
-