--- "Duzenbury, Rich" <[EMAIL PROTECTED]> wrote:
> > > > -----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 > I couldn't find it with a quick trip through the docs but I seem to remember that using a single period for your host name will force an election to either use the socket or use the IP stack. I'm sorry but I don't remember which way it forces the client to connect but I do know it's only for local connections. shell>mysql -uxxxx -p -h. -P3307 HTH! Shawn Green Database Administrator Unimin Corporation - Spruce Pine __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]