topic WFA 2.0 Can't log into MySQL database in Active IQ Unified Manager Discussions

WFA 2.0 Can't log into MySQL database

TIMHOIBERG — Thu, 05 Jun 2025 06:13:44 GMT

I was wondering if any changes were made to accessing the MySQL database in WFA 2.0. I just upgraded to 2.0 from 1.1.1 and noticed that I can't log into the database. For reference I'm using MySQL Workbench 5.2 CE and using the same settings as I was previously. However, instead of a dialog box asking for the password I get the error message: "Your connection attempt failed for user 'wfa' from you host to server vbnewfa4001:3306:"

Settings I'm using:

Username: wfa

Hostname: vbnewfa4001 (Our WFA server)

Port: 3306

This configuration worked fine on WFA 1.1.1. Any help would be much appreciated.

Re: WFA 2.0 Can't log into MySQL database

sinhaa — Mon, 17 Dec 2012 06:49:57 GMT

You can try this:

1. Stop your NetApp WFA Database service

2. Go to NetApp/WFA/mysql folder and open file my.ini using any editor (notepad)

3. The bottom line will be "bind-address=localhost". Comment this line out by placing a # in the beginning

4. Start the NetApp WFA Database service and WFA Server service.

Now attempt to login.

Re: WFA 2.0 Can't log into MySQL database

TIMHOIBERG — Mon, 17 Dec 2012 11:47:49 GMT

Thanks sinhaa I can now log in, although it doesn't require a password anymore.

Re: WFA 2.0 Can't log into MySQL database

yaronh — Mon, 17 Dec 2012 11:55:30 GMT

Hi Tim,

Just to add to the former reply:

Due to security scrutiny we decided to block remote-access to the database by default.

As suggested by Sinha, this block can be overridden for customers who wish it so.

Best,

Yaron Haimsohn

WFA Team

Re: WFA 2.0 Can't log into MySQL database

TIMHOIBERG — Tue, 18 Dec 2012 00:42:20 GMT

Hi Yaron,

Is there a particular application for accessing the database you can suggest? As mentioned I'm using MySQL Workbench 5.2 CE but I couldn't find a 64-bit version and the 32-bit version seems to be quite buggy on my WFA server.

Re: WFA 2.0 Can't log into MySQL database

sinhaa — Tue, 18 Dec 2012 08:17:21 GMT

If I may answer to you Tim,

I am using DbVisulizer 9.0.1 which is a good Database client tool. Its freely downloadable from : http://www.dbvis.com/

There is a licensed enterprise edition too.

Another powerful ( but licensed) DB tool is SQLyog Enterprise - MySQL GUI

Re: WFA 2.0 Can't log into MySQL database

yaronh — Tue, 18 Dec 2012 10:10:31 GMT

Hi Tim,

I am using SQLYog from www.webyog.com. Not sure what their pricing scheme though but I understood it's quite affordable.

They have a month long trial if you like.

I checked the DbVisualizer and it seems great for viewing data and running queries, but the free version can't edit data (Which might be useful).

Another option I used once is Navicat. They are also quite nice and once had a free version. http://www.navicat.com/

Googling, also found this one - http://www.mysqlajaxtableeditor.com
which seems really cool

Yaron

Re: WFA 2.0 Can't log into MySQL database

hland — Tue, 18 Dec 2012 16:04:06 GMT

There's also a pre-configured package of open-source components available from this post: https://communities.netapp.com/message/72997#72997

..- Hendrik

Re: WFA 2.0 Can't log into MySQL database

mhofstet — Tue, 22 Jan 2013 13:37:18 GMT

This has fixed my issue. But still, on the WFA server I still can't loging with the "localhost" settings with the bind-address settings...

but the #bind-address has fixed it.

Marc