Active IQ Unified Manager Discussions

how to connect Mysql workbench to OCUM database

maskajan09

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

2 REPLIES 2

Re: how to connect Mysql workbench to OCUM database

niels

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

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

Earn Rewards for Your Review!
GPI Review Banner
All Community Forums
Public