Paul, Your probably right about him running on windows, but I have also seen this in other situations running linux. In fact, and yes I am almost ashamed to say, I even set one up this way in my earlier days. It was on a local network with no internet, and the "users" were on a custom app connecting through libmysql.dll. I know, not the smartest thing to do but the "users" had no Idea about computers and probabaly didn't even know there was a DB server. So let the tongue lashing commence.
Roger > -----Original Message----- > From: Paul DuBois [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 08, 2003 10:02 PM > To: Roger Davis; [EMAIL PROTECTED] > Subject: RE: [EMAIL PROTECTED] > > > At 21:17 -0400 7/8/03, Roger Davis wrote: > >localhost does not mean 127.0.0.1 Localhost is the socket to > connect to and > >has is separate from IP addresses. The % is for IP address > access. That is > >why there are 2 ways. I would hardly call that redundant. > > > >Roger > > That's true on Unix, but if Jim (the original poster) has entries > for [EMAIL PROTECTED] and [EMAIL PROTECTED], then he's probably running on Windows, > and Unix sockets are irrelevant. localhost can be used for named pipe > connections, though: the [EMAIL PROTECTED] entry will work for that, > whereas [EMAIL PROTECTED] will not. > > Note too that because [EMAIL PROTECTED] allows access to any remote host anywhere, > it's particularly important to make sure either that that account has > a password or that you remove it. Otherwise your server is wide open. > > > > > > >> -----Original Message----- > >> From: Joel Rees [mailto:[EMAIL PROTECTED] > >> Sent: Tuesday, July 08, 2003 8:30 PM > >> To: [EMAIL PROTECTED] > >> Subject: Re: [EMAIL PROTECTED] > >> > >> > >> > Not sure where these came from, but in my users I've got a > >> [EMAIL PROTECTED] and a > >> > [EMAIL PROTECTED] Is this redundant, or is there a reason for this? > >> > >> Well, some people might say it's redundant, but it _is_ by design -- > >> > >> http://www.mysql.com/doc/en/Privileges.html > >> > >> > ... > >> > >> -- > >> Joel Rees, programmer, Kansai Systems Group > >> Altech Corporation (Alpsgiken), Osaka, Japan > > > http://www.alpsgiken.co.jp > > > -- > 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.497 / Virus Database: 296 - Release Date: 7/4/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.497 / Virus Database: 296 - Release Date: 7/4/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]