|
it seems not possible.
however, you may solve with a little trick in Linux systems...
For example:
If you have a Linux Machine with MySQL. and
the computers which will connect to the database has IP numbers
212.45.64.20 and 212.45.64.21
Then, allow user to connect from 212.45.64.???
and deny the port number of MySQL Server from all IP numbers, except
212.45.64.20, and 212.45.64.21
then, You have 1 user, which can connect from two IP numbers
(in fact too many IP's in the same class BUT ..)
then increase SEUCRITY of your FIREWALL about MySQL
PORT.
best regards...
-------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
. |
