View incoming query requests to MySQL server
mysql, profiler
Solution
Sounds like you want the mysql query log
Edit: Try this:
- Edit my.cnf in /etc/mysql/my.cnf
- /etc/init.d/mysql restart
- Look in /var/log/mysql
Problem
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.