When logging in from another machine on a mysql 4.19 server, there is a
delay of about 5 seconds.

A new mysqld thread is started right away, but other activity occurs 5
sec later.

When accessing this server via PHP on the same machine as the server, no
such delay occurs.


The users are known to the server as name@168.165.1.%
a setting skip-name-resolution is added to the config for [mysqld]



what could be the cause of this delay?

Solution found:

adding lines for the involved machines in

c:\windows\system32\drivers\etc\hosts

with some fake hostnames


Gert Kok wrote:
> When logging in from another machine on a mysql 4.19 server, there is a
> delay of about 5 seconds.
>
> A new mysqld thread is started right away, but other activity occurs 5
> sec later.
>
> When accessing this server via PHP on the same machine as the server, no
> such delay occurs.
>
>
> The users are known to the server as name@168.165.1.%
> a setting skip-name-resolution is added to the config for [mysqld]
>
>
>
> what could be the cause of this delay?