[SOLVED] Connect to zimbra's database (ubuntu)

[ruben.rodrigues]

Hi!

I want to connect to Zimbra's databases using the Mysql query browser or the Mysql administrator. I need some tips couse everytime I try to change something I lose mysql base installation and then I have to reinstall mysql-server pack.

1-so basically I need to know how should the /etc/mysql/my.cnf look like (if it matter)
2-How do I make it the default database
3-Anything that I'm not refering but could help

Thanks

[phoenix]

Originally Posted by ruben.rodrigues

Hi!

I want to connect to Zimbra's databases using the Mysql query browser or the Mysql administrator. I need some tips couse everytime I try to change something I lose mysql base installation and then I have to reinstall mysql-server pack.

It's not advised to make any changes to the MySQL database, you may lose your data and if you do make changes they're not guaranteed to be maintained during any upgrade.

[ruben.rodrigues]

Originally Posted by phoenix

It's not advised to make any changes to the MySQL database, you may lose your data and if you do make changes they're not guaranteed to be maintained during any upgrade.

I just want to backup the database using a remote tool with GUI. So if you know, please, tell me

[miguel.a.velasco]

To connect from Remote GUI Client to Zimbra Mysql follow this guide: Mysql Tunneling On Zimbra | My Online Log

I hope, it helps you!
Miguel

[ruben.rodrigues]

Originally Posted by miguel.a.velasco

To connect from Remote GUI Client to Zimbra Mysql follow this guide: Mysql Tunneling On Zimbra | My Online Log

I hope, it helps you!
Miguel

The idea is good but doesn't work because my server's port is not open and not listening to the zimbra's database.

How can I fix this?

[ruben.rodrigues]

Ok. So now I have the port open. Just tell me how do I give access to remote users because I still get the error:
"Access denied for user 'zimbra'@'192.168.1.121' (using password: YES)"
that means that the localhost is the only one with access permission.

thanks