I am using Mysql 5.6.12 under Wamp server environment. Now I want to log All queries into ".log" file, the queries which are running by PHP or from PHPMyAdmin, I want to log them...
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Note that enabling
If you use these two lines in my.cnf, I find that it works fine. This will log all queries to the server, from any source, not just PHP/PHPMyAdmin. Paul...
Be careful though - enabling the general log can place a heavy load on your server. To be used sparingly for short periods/debugging only.