MySQL-Proxy and histogram.lua

[Daniel Souza]

hey guys,

I'm trying to use mysql-proxy to collect query information using the histogram.lua script. I got mysql-proxy started with "/opt/mysql-proxy-0.6.1/bin/mysql-proxy --pid-file=/opt/mysql-proxy-0.6.1/mysql-proxy.pid --admin-address=127.0.0.1:4041 --proxy-address=127.0.0.1:4040 --proxy-backend-addresses=192.168.2.71:3306 --proxy-lua-script=/opt/mysql-proxy-0.6.1/examples/histogram.lua" . Connecting to the mysql via the proxy works fine, but when I try some thing like "select * from histogram.queries" it gives out an error "ERROR 1142 (42000): SELECT command denied to user 'root'@'db2' for table 'queries'" like it is passing through instead of being treated by the lua script... how do I get the histogram info to work fine ?