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