How to check MySQL password on Zimbra server

Zimbra uses a MySQL database to store operational data. Normally, when you access mysql while logged in as zimbra, you do not need to enter a MySQL password. However, if you need to use MySQL as the root user or back up the database with a program that requires a password, you can check the MySQL passwords for root and zimbra by running:

[root@mail ~]# su - zimbra
[zimbra@mail ~]$ zmlocalconfig -s | grep mysql | grep password

The output will resemble this example:

antispam_mysql_password =
antispam_mysql_root_password =
mysql_root_password = L2hstA0pEOGCubxXAOEfRFnHZ9w3yu
zimbra_mysql_password = lgMvAuXDycX0TWQJ6wiAAfH7xjsF0