A pseudo-Sql server to intercept and see all MySQL queries

Question

I would like to setup a "pseudo-server" to intercept all the SQL queries made by my local application.

The reason for that is that I can't administer the Mysql server, and it's difficult for me to edit the configuration files to enable any logging. The easiest way would be to have a Sql "router" that would redirect all my queries to the original server, but log them for me to debug. That way I would only have to set the server URL to localhost (and configure the username).

score 3 · Accepted Answer · answered Jun 14 '11 at 16:21

3

Check out http://forge.mysql.com/wiki/MySQL_Proxy

answered Jun 14 '11 at 16:21

faker

17,496
2
60
70

Perfect, a bit tricky to set up, but now it works! – Matthieu Napoli Jun 15 '11 at 08:06
1

I also recommend using the following script: http://forge.mysql.com/tools/tool.php?id=80. – Matthieu Napoli Jun 15 '11 at 08:06

A pseudo-Sql server to intercept and see all MySQL queries

1 Answers1