One more thing...
Are you sure that user/host and db fields are primary keys such
that they does not accept double/triple entrance?
My User Table is something like this.
Host
User
====
=========
localhost
root
localhost
sait
localhost
wtc-admin
some_host
testuser
and DB table is
Host
Db
User
====
==========
============
%
test
%
test\_%
localhost
phphelpdesk
phphdadmin
localhost
phphelpdesk
helpdesk
So it seems that, you can INPUT multiple HOSTs, multiple, USERs and
multiple DBs...
Have a nice day...
-------Original Message-------
Date: 11 Ocak 2002 Cuma
15:04:52
Subject: setup 1 user
to connect from 2 hosts.
What is the correct way of having 1 user connect from
only 2 hosts to the same database? Since user,host, and db fields are
all primary keys in the all of the user, host, db tables. I can't enter
a user twice with diffrent hosts as I had planned on doing it. I'd
prefer to explicitly state the two hosts, they are on seperate networks
so it would be tough to wildcard group them
together.
--------------------------------------------------------------------- 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 . |