Connecting to zimbra_logger from remote host

[anton.aleksandrov]

Hello,
Is it possible to grant permission to connect to zimbra_logger database from a remote host? I would like to make sort of statistic page to monitor senders and recipients and keep it in a separate database/host. When I do "logmysql" as zimbra user, it seems I am lacking permissions to grant anything..

Anton.

[uxbod]

Please update your profile with the following so we know which version of ZCS you are running

su - zimbra
zmcontrol -v

[anton.aleksandrov]

Sure.
Release 5.0.11_GA_2695.UBUNTU8_64 UBUNTU8_64 NETWORK edition

[uxbod]

su - zimbra
zmlocalconfig -s | grep -i mysql

You will then get the root password which you can use to connect to MySQL and grant access.