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 [EMAIL PROTECTED] IDENTIFIED BY password
You can list as many permission as needed, separated by commas.
----- Original Message -----
From: "Robin Kopetzky" <[EMAIL PROTECTED]>
To: "PHP DB Group" <[EMAIL PROTECTED]>
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"
> 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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php