topic how to connect Mysql workbench to OCUM database in Active IQ Unified Manager Discussions

how to connect Mysql workbench to OCUM database

maskajan09 — Wed, 04 Jun 2025 13:23:20 GMT

Hello

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

Jan

Re: how to connect Mysql workbench to OCUM database

niels — Mon, 27 Aug 2018 12:46:20 GMT

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:

https://www.netapp.com/us/media/tr-4709.pdf

regards, Niels

----

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

Re: how to connect Mysql workbench to OCUM database

helge — Tue, 18 Sep 2018 07:38:35 GMT

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....