you are correct, my assumption was wrong, you can add the same user to the user table twice, I'm assuming as long as the host-user combination is unique.
On Fri, 2002-01-11 at 07:50, Sait Karalar wrote: > 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------- > > From: Jeff Bearer > Date: 11 Ocak 2002 Cuma 15:04:52 > To: [EMAIL PROTECTED] > 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 <mysql-unsubscribe-sait=marketweb.net.tr@lists > mysql.com> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > . -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.com --------------------------------------------------------------------- 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