Restrict Access to root account

[James O'Hara]

Hey Guys,

I've been playing about with mysql-proxy and SSH tunnelling recently and come up with something that works for my situation.

One problem I currently cant get round is I'm using Mysql-proxy to connect to a MySQL cluster that doesn't have a password for the root@localhost account.

Because of this I would like to use mysql-proxy to simply either block any queries trying to use the root user or change the root user to another user (that will exist on the server) that has a password set.

Does anyone have any idea how I'd go about this? I've spent a few days checking out the lua examples and my head is spinning right now.

Its getting to the point now where I might need to pay someone to do this for me so where would be the best place to advertise for that?

Thank you,
James