Not on my testing system (Win-XP). I test on Win-XP but deploy on Unix.
Not only that, but the production application servers are separate from
the database server, so I never use localhost in production anyway.
But on the XP test server, I had to add the 127.0.0.1 entries to 'db'
and 'user' - 'localhost' alone did not work. I did not test whether or
not 'localhost' would work on a Unix server as this was not something I
required. Would be a good test, though.
Cheers,
-Richard
Martin Gainty wrote:
Richard-
That should work..curious if localhost is mapped elsewhere?
Martin
______________________________________________
Disclaimer and confidentiality note
Everything in this e-mail and any attachments relates to the official
business of Sender. This transmission is of a confidential nature and
Sender does not endorse distribution to any party other than intended
recipient. Sender does not necessarily endorse content contained
within this transmission.
> Date: Fri, 24 Oct 2008 07:51:44 -0700
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> CC: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: Re: Stopping DNS Lookups
>
> Yes, that's exactly what the link from Hassan said to do.
>
> Interestingly, what is not stated in that link is that you must add
> entries in mysql tables 'db' and 'user' for '127.0.0.1' (a.k.a.
> 'localhost') if you need to access the database from the local server.
> Remote access via static IP (assuming those entries were already in
'db'
> and 'user') work fine, but 'localhost' no longer works after the reboot.
>
> Cheers,
>
> -Richard
>
> Moon's Father wrote:
> > Add skip-name-reslove in my.cnf and restart mysql immediately.
> >
> > On Thu, Oct 23, 2008 at 12:37 AM, Richard S. Huntrods
> > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
> >
> > Awesome! Thanks very much - exactly what I was looking for. I'm in
> > the field and was under the gun, otherwise would have checked the
> > manuals first.
> >
> > Again, thanks.
> >
> > -Richard
> >
> >
> > Hassan Schroeder wrote:
> >
> > On Wed, Oct 22, 2008 at 7:40 AM, Richard S. Huntrods
> > <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
> >
> >
> >
> > Recently I had to start monitoring the firewall traffic on
> > this intranet,
> > and discovered the MySQL server is routinely sending
> > queries to the main DNS
> > server (outside the firewall). I suspect the server is
> > performing "reverse
> > DNS lookups" for some reason.
> >
> > Is there a quick way of disabling these calls to the DNS
> > server?
> >
> >
> >
> > See <http://dev.mysql.com/doc/refman/5.0/en/dns.html>
> >
> > HTH,
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> >
> >
> > --
> > I'm a MySQL DBA in china.
> > More about me just visit here:
> > http://yueliangdao0608.cublog.cn
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
------------------------------------------------------------------------
You live life beyond your PC. So now Windows goes beyond your PC. See
how <http://clk.atdmt.com/MRT/go/115298556/direct/01/>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
