View incoming query requests to MySQL server

Question

is there a way we can view the incoming query requests to mysql server. I have a scenario where my asp.net application refuses to execute a query, but the same query executes inside of a mysql query browser. I have installed the mysql dotnet connector (5.0.9) via which I can conncet to the database.

I have referred this page, but I guess this will only work within the mysql session. The mysql server is hosted on a centos machine.

Answer 1

Sounds like you want the mysql query log

Edit: Try this:

1. Edit my.cnf in /etc/mysql/my.cnf
2. /etc/init.d/mysql restart
3. Look in /var/log/mysql