We have 4 development servers that are fairly configured the same way.
We have an admin account on each server using %" for the hostname. This
works on 3 of the 4 servers. The 4th server seems to do a lookup and
since the client machine (i.e. my workstation) isn't specifically
specified access is denied.

I know I can disable the resolution and use IP's instead but is there a
way to enforce "%"? It seems that even though I have "%" in place it
still rejects because of the reserves DNS.

Gary

> We have 4 development servers that are fairly configured the same way.
> We have an admin account on each server using %" for the hostname.
> This
> works on 3 of the 4 servers. The 4th server seems to do a lookup and
> since the client machine (i.e. my workstation) isn't specifically
> specified access is denied.
>
> I know I can disable the resolution and use IP's instead but is there
a
> way to enforce "%"? It seems that even though I have "%" in place it
> still rejects because of the reserves DNS.

I found the source of the problem. Apparently it was a service stuck
between the chair and the keyboard...

While playing around with development replication I removed some of the
log files and one of the test databases manually and I guess I also
removed the mysql directory. When the service was started it created
them, as expected but since they were new the login account was gone.