Connecting directly to WFA Mysql

Hi, it's possible to connect directly to the mysql instance of WFA (also with a user with read only access)?

I ask this because I need to to some filters on the sql tables of WFA and I'm not an sql expert so using some external tools to create and check the query will be really useful (the web interface to create and check the query is not so good).

Re: Connecting directly to WFA Mysql

‎2012-01-2903:53 PM

I will not need root access but having a read only user will be great just to be able to create some query. The web interface of WFA is great but writing queries directly is not the simplest of the things

Re: Connecting directly to WFA Mysql

‎2012-01-3007:12 AM

I agree, DB access can be really helpful for testing SQL queries or even for just checking what the values in the cache DB are. We should have at least an option to configure a read-only user that can be used by customers. Maybe not as a hard-coded user with default password but something that can be configured within the WFA options?

Yaron, could you track this as a feature request? ;-)

Regards

Hendrik

PS: I'm experimenting with a web-based solution to access the WFA cache DB in a comfortable manner (as an alternative to SQLyog which requires an RDP session). Will post results in the next few days...