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.


cheers,

feng


----- 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"
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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to