My SQL wrote:
yes the PHP apps stop working when the server is stopped, the PHP apps
are all connecting to the MySQL on the machine..
All the other queries are logged including the connect statements,
except for the queries from PHP on the same machine !!
I don't think you're understanding what I'm asking.
You said that you have two physical machines running these PHP
applications, called them "A" and "B". "A" is your machine. "B" is
what you describe as "another machine" in your original post on this
topic. The SQL queries are logged correctly on machine A, but
apparently are not logged correctly from PHP apps on machine B.
The PHP apps connect to a MySQL database. By doing so, they must
specify a host to which to connect. The host may be the same machine on
which the PHP apps run, but is not necessarily the same machine. PHP
can connect to MySQL running on any machine on the network. It depends
on the PHP code that makes the database connection. I'm assuming that
machines A and B are reachable to each other on your network.
My guess is that the PHP apps running on machine B are connecting to the
MySQL service on machine A. If that is the case, you'll find the
queries logged on machine A.
You can check the database connection code in your PHP apps on machine B
to verify. I suggested another way to verify was to shut off MySQL on
machine A and see if the PHP apps on machine B complain about the lack
of a database.
Regards,
Bill K.