Community maintenance is complete. Thank you for your patience!

Active IQ Unified Manager Discussions

how to connect Mysql workbench to OCUM database



the subject says it all. OCUM 9.4 vmware appliance. I know how to enable diag user and then how to connect to the mysql db using ssh and then sudo mysql. It looks like the port 3306 needs to be enabled somewhere and also I don't know how to connect via mysql user.


Please help.

Thank you




you need to add a user which has the right to access from remote IPs.


in mysql cli do something like

grant select on *.* to remote@'%' identified by 'password';


The port is accessible by default in OVA - if you have Windows, RHEL or CentOS you need to modify the firewall settings accordingly.

Then connect Workbench with this user. With "select" in the example the user has only read rights. Editing may have unexpected results....


Hi Jan,


no need to enable the diag user and work your way through the CLI. There is an easier and officially documented way to get to the data:


regards, Niels



If this post resolved your issue, please help others by selecting ACCEPT AS SOLUTION or adding a KUDO or both.

NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner