Re: User is rejected because of IP, but hostname is allowed - sheeri kritzer - com.mysql.lists.mysql

7 messages in com.mysql.lists.mysqlRe: User is rejected because of IP, b...

From	Sent On	Attachments
Ryan Stille	16 Feb 2006 14:22
Kishore Jalleda	16 Feb 2006 14:31
Ryan Stille	16 Feb 2006 14:39
Kim Christensen	17 Feb 2006 02:52
Kim Christensen	17 Feb 2006 02:54
Ryan Stille	17 Feb 2006 06:29
sheeri kritzer	20 Feb 2006 09:25

Subject:	Re: User is rejected because of IP, but hostname is allowed
From:	sheeri kritzer (awf...@gmail.com)
Date:	02/20/2006 09:25:06 AM
List:	com.mysql.lists.mysql

Why not also put a wildcard for 192.168.% ? That's what we've done.

-Sheeri

On 2/17/06, Ryan Stille <rp...@willcomminc.com> wrote:

did u start mysql with --skip-name-resolve ??? Kishore Jalleda

Kim Christensen wrote:

On 2/16/06, Ryan Stille <rp...@willcomminc.com> wrote:

Nope.

Well, have you tried it? Did it solve your problem?

Sorry, I misunderstood. I thought Kishore was saying that if I had started the server with that option, that could be the cause of my problem. I'd really rather not restart the server, as it is a production system. I can schedule to have it done if I must.

After looking in the manual I don't know if the --skip-name-resolve option would help me. It says: "Hostnames are not resolved. All Host column values in the grant tables must be IP numbers or localhost." - I don't want to specify IP's in my grant tables, I want to use a wildcard at my domain: %.willcomminc.com.