Re: Problem When Mysql runs on a Machine with multiple NIC.
Specify other account(s)? [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] etc... "Me fail English? That's unpossible" ###___Archon___### - Original Message - From: "P Srinivasulu" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, July 10, 2003 2:40 PM Subject: Re: Problem When Mysql runs on a Machine with multiple NIC. > >>> Paul DuBois <[EMAIL PROTECTED]> 7/10/2003 10:22:27 AM >>> > At 2:30 -0600 7/9/03, P Srinivasulu wrote: > >>When Mysql runs on machine with multiple NIC's. Mysql server takes > the > >>IP Address that we specify in the configuration file. This IP > Address > >>may or may not be a primary IP Address of that machine. So we > specify > >>secondary IP Address for the Mysql server. It listens in that IP > >>Address. > >> > >> When Mysql client from the same machine connects to that server, > Mysql > >>Client is treated,as if the connection is coming from the different > >>host. i.e. The Rights of the Mysql client will not be same as the > rights > >>of [EMAIL PROTECTED] instead it will be equal to the rights of the > >>[EMAIL PROTECTED] Is this behaviour correct or a bug. > > >This is correct behavior. > > >MySQL doesn't know that localhost and PrimaryIPAddress are the same > >host. > > How to make the mysql client to use the secondary IP Address to connect > to the Mysql server?. > > > Thanks, > Srinivasulu. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem When Mysql runs on a Machine with multiple NIC.
>>> Paul DuBois <[EMAIL PROTECTED]> 7/10/2003 10:22:27 AM >>> At 2:30 -0600 7/9/03, P Srinivasulu wrote: >>When Mysql runs on machine with multiple NIC's. Mysql server takes the >>IP Address that we specify in the configuration file. This IP Address >>may or may not be a primary IP Address of that machine. So we specify >>secondary IP Address for the Mysql server. It listens in that IP >>Address. >> >> When Mysql client from the same machine connects to that server, Mysql >>Client is treated,as if the connection is coming from the different >>host. i.e. The Rights of the Mysql client will not be same as the rights >>of [EMAIL PROTECTED] instead it will be equal to the rights of the >>[EMAIL PROTECTED] Is this behaviour correct or a bug. >This is correct behavior. >MySQL doesn't know that localhost and PrimaryIPAddress are the same >host. How to make the mysql client to use the secondary IP Address to connect to the Mysql server?. Thanks, Srinivasulu. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem When Mysql runs on a Machine with multiple NIC.
At 2:30 -0600 7/9/03, P Srinivasulu wrote: When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of [EMAIL PROTECTED] instead it will be equal to the rights of the [EMAIL PROTECTED] Is this behaviour correct or a bug. This is correct behavior. MySQL doesn't know that localhost and PrimaryIPAddress are the same host. Thanks, Srinivasulu. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem When Mysql runs on a Machine with multiple NIC.
When Mysql runs on machine with multiple NIC's. Mysql server takes the IP Address that we specify in the configuration file. This IP Address may or may not be a primary IP Address of that machine. So we specify secondary IP Address for the Mysql server. It listens in that IP Address. When Mysql client from the same machine connects to that server, Mysql Client is treated,as if the connection is coming from the different host. i.e. The Rights of the Mysql client will not be same as the rights of [EMAIL PROTECTED] instead it will be equal to the rights of the [EMAIL PROTECTED] Is this behaviour correct or a bug. Thanks, Srinivasulu. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
