grant alter, create, delete, drop, insert, select, update, index ON
name_of_database.* to name_of_database TO username@localhost identified by
"password" with grant option;
then
grant alter, create, delete, drop, insert, select, update, index ON
name_of_database.* to name_of_database TO username@%.ourdomain.com
identified by "password" with grant option;
should do the trick for you.
Curtis Maurand
President
Maine Line Systems
On Mon, 1 Oct 2001, Erica Douglass wrote:
> Hi,
>
> I am working with an internal database. We add a user using the
> following statements:
>
> create database name_of_database;
>
> GRANT alter, create, delete, drop, insert, select, update, index ON
> name_of_database TO username@localhost identified by "password" with
> grant option;
>
> GRANT alter, create, delete, drop, insert, select, update, index ON
> name_of_database TO username@%.ourdomain.com identified by "password"
> with grant
> option;
>
> flush privileges;
>
> First of all, the second statement gives an error message. What is the
> correct syntax for adding user@%.ourdomain.com?
>
> Also, when logging in as the newly created user, I can't create any
> tables under the newly created database. If I go into phpMyAdmin and
> give a "create" permission to the new user, that user gets it on all
> databases, which I don't want.
>
> I am very, very frustrated. I just want each user to have their own
> database that they can do whatever they want with, without letting them
> see all the other databases. I know this is possible.
>
> Please help.
>
> Thanks,
> Erica
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
