Re: Confused
| From: | Wang Feng | Date: | Sun, 05 Oct 2003 16:35:15 +0000 |
| Subject: | Re: Confused | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30850@lists.php.net to get a copy of this message | ||
I assume you're using MySQL since L.A.M.P seems very popular.
The following command should work anyway:
GRANT permission ON tablename TO accountname@hostname IDENTIFIED BY password
You can list as many permission as needed, separated by commas.
cheers,
feng
----- Original Message -----
From: "Robin Kopetzky" <sparkyk@blackmesa-isp.net>
To: "PHP DB Group" <php-db@lists.php.net>
Sent: Monday, October 06, 2003 1:44 AM
Subject: [PHP-DB] Confused
> I need to setup a user, 'commerce' with a password, that can be accessed
> from any web server in our farm 'blackmesa-isp.net'. What "GRANT"
statement
> do I need to make this work? I've tried a bunch of the examples in the
> manual and can't get it right. Specifically, I need the user to CONNECT,
> SELECT, INSERT, UPDATE, DELETE and that's all for privileges.
>
> Any help is appreciated.
>
> Robin 'Sparky' Kopetzky
> Black Mesa Computers/Internet Service
> Grants, NM 87020
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php