On Sunday 05 October 2003 23:44, Robin Kopetzky wrote:
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
El Dom 05 Oct 2003 12:44, Robin Kopetzky escribió:
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
El Dom 05 Oct 2003 13:07, Jason Wong escribió:
On Sunday 05 October 2003 23:44, Robin Kopetzky wrote:
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
: [PHP-DB] Confused
On Sunday 05 October 2003 23:44, Robin Kopetzky wrote:
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
Jason,
There are good reasons for having different lists for different subjects.
Note, he post the message to the [EMAIL PROTECTED] rather than
[EMAIL PROTECTED] There's nothing wrong to ask questions @ php-DB.
:-)
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
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:
To answer your question, yes, I'm using mysql. No, I did not intended for
everyone to go thermonuclear over this question. Next time, I'll go
elsewhere since some one got P.O.'d about my posting twice.
Sparky
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
.
M
-Original Message-
From: Robin Kopetzky [EMAIL PROTECTED]
Date: Sun, 5 Oct 2003 13:56:10
To:[EMAIL PROTECTED]
Subject: RE: [PHP-DB] Confused
To answer your question, yes, I'm using mysql. No, I did not intended for
everyone to go thermonuclear over this question. Next time, I'll go
if i'm reading right, you could use a join to get all of that info.
select users.group_id, user_id, user_name, groups.group_name from users
inner join groups on (groups.group_id = users.group_id) group by
users.group_id
parens not needed, it just makes it more legible.
that should give you an