MySQL Log of invalid Queries

Question

I AM NOT RUNNING THE COMMANDS FROM PHP!

I have MySQL log_error value set to /var/log/mysql/error.log

However when I connect to a database and run an SQL command, the error does not appear in the log.

 SELECT *  FROM some_table where this_is_invalid_and_will_fail="Doesn't matter because column doesn't exist!"; 

There are commands running from some sort of windows application. All I want to know is what invalid commands its sending to the MySQL server so that I can attempt to resolve them.

Answer 1

Error log doesn't do that: https://dev.mysql.com/doc/refman/8.0/en/error-log.html

The error log contains information indicating when mysqld was started and stopped and also any critical errors that occur while the server is running.

MySQL doesn't log invalid/failed queries anywhere.

---

If it's for debugging purposes, you might try setting up a MySQL Proxy, which could log this I think:

http://dev.mysql.com/downloads/mysql-proxy/