List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:September 6 2005 1:01pm
Subject:Re: query-log.html
View as plain text  
Hello.

> host when I have hostnames in the 'user' table. It will only
> work with ip addresses. (This is where I came in originally).

Are you sure that you're running MySQL without --skip-name-resolve? See:
  http://dev.mysql.com/doc/mysql/en/dns.html



> 
> I think I must have had my head screwed on the wrong way round
> when I was looking at the log file. I've deleted it now, but
> I think what I was seeing was the remains of the logging generated
> by the prev version of mySQL (3.23) just before I upgraded to
> 4.1. No new logfile has been generated since deleting this.
> Sorry to waste your time!
> 
> BUT - I still cant get mysqld to let me connect from a remote
> host when I have hostnames in the 'user' table. It will only
> work with ip addresses. (This is where I came in originally).
> And the distributed Alpha binary doesnt jhave the debug option
> compiled in, so I guess I'll have to build it from scratch
> to investigate further.
> 
>>
>>
>>
>>What version of MySQL are you running?
> 
> 4.1 precompiled Alpha binaries.
> 
> Thanks,
> Terry.
> 
>>
>>
>>
>>
>>
>>
>>
>>"T. Horsnell" <tsh@stripped> wrote:
>>
>>> Someone kindly replied to my log query today, but I unfortunately
>>
>>> deleted the message.
>>
>>> They referred me to this URL:
>>
>>> 
>>
>>> http://dev.mysql.com/doc/mysql/en/query-log.html
>>
>>> 
>>
>>> Trouble is, I dont start mysqld with the --log= option,
>>
>>> and yet it still insists on logging. How do I disable this?
>>
>>> (My current method is to use --log=/dev/null but I'm sure
>>
>>> this cant be the best way). I cant find any evidence of
>>
>>> a my.cnf anywhere, so I dont think it is due to an unexpected
>>
>>> config-file option
>>
>>> 
>>
>>> 
>>
>>> 
>>
>>> Cheers,
>>
>>> Terry.
>>
>>> 
>>
>>
>>
>>

-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
query-log.htmlT. Horsnell3 Sep
  • Re: query-log.htmlAlexey Polyakov3 Sep
  • Re: query-log.htmlGleb Paharenko5 Sep
    • Re: query-log.htmlT. Horsnell6 Sep
      • Re: query-log.htmlGleb Paharenko6 Sep