Active IQ Unified Manager Discussions

how to connect Mysql workbench to OCUM database

maskajan09
3,213 Views

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

niels
3,200 Views

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.

helge
3,003 Views

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

Public