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
.
____________________________________________________
  IncrediMail - Email has finally evolved - Click Here

Reply via email to