> -----Original Message----- > From: Barry [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 13, 2006 9:41 AM > To: mysql@lists.mysql.com > Subject: Re: MySql Error Number 1130 > > Duzenbury, Rich wrote: > >>localhost means socket. > > > > > > Hmm, I don't believe it does. localhost is a DNS shortcut > to the IP > > address of the local machine. > > > > If that is how mysql wants to treat things, then it should issue an > > error message on connect because --host=localhost and > --port=anything > > would then be mutually exclusive. > > > > Thanks. > > > > Regards, > > Rich > > Wasn't it something like on local machines MySQL doesn't open > a socket port because it works directly in program and not > going the loop out of mysql and back in through the socket? >
I'm not sure I understand your statement. It's wise to use a unix domain socket where possible because they perform better than network sockets. However, it's misleading for the mysql client to ignore a command line directive as important as --port or --host without warning. Especially since this can cause connection to the wrong instance. Another way this would have been made more obvious is if the welcome message in the client were a bit more descriptive. Currently, I see 'Your mysql connection id is 2 to server version: 5.0.18-standard-log'. Perhaps the client should indicate the socket or ip/port that was actually used in the welcome message. Thanks. Regards, Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
