2016-03-21 07:37 AM - edited 2016-03-21 07:37 AM
If you want to interface directly with the mysql DB remotely you will need to first comment out the "bind-address" line within the my.ini under <install dir>\Netapp\WFA\mysql. Once you have commented out the line, you will need to restart the 'NetApp WFA Database' service for the change to take affect. This will allow you to connect from any PC of your liking with a tool like mysql workbench, or whatever tool you prefer.
If you only want to access the database from the machine WFA is installed on, you don't have to do the above since it is already locked down to just that PC. If you want to run a query from the CLI, pop into powershell and run the profile of WFA's Service. <install dir>\Netapp\WFA\Posh\profile.ps1 After you do that, you will have 'Invoke-mysqlquery'. You can test it by running something simple like 'invoke-mysqlquery "select * from cm_storage.cluster" '
The account to access the database is "wfa" and password is "Wfa123".
I hope that answers your question(s).
2016-03-24 02:10 AM
WFA3.0 and above provided WFAConfig cmdlets to do this for you. Its done to avoid the need for users to manually edit the configurations files. Read more about them in WFA Installation and setup guide.
WFA3.0: Open WFA\bin and launch ps.cmd to launch a powershell console with WFA modules loaded.
Set-WfaConfig -Name DBAccess -Enable $true
Restart service when prompted for.
In WFA3.1+ in addition to the above, you can also use
1. Open a cmd.exe and go to \WFA\bin.
2. There is a wfa.cmd uitility avaibale.
./wfa --db-access=public --restart