{"id":5215,"date":"2014-07-10T05:28:28","date_gmt":"2014-07-09T21:28:28","guid":{"rendered":"https:\/\/webhostinggeeks.com\/howto\/?p=5215"},"modified":"2023-04-28T09:48:17","modified_gmt":"2023-04-28T09:48:17","slug":"how-to-display-mysql-root-password-in-zimbra","status":"publish","type":"post","link":"https:\/\/webhostinggeeks.com\/howto\/how-to-display-mysql-root-password-in-zimbra\/","title":{"rendered":"How to Display MySQL root Password in Zimbra"},"content":{"rendered":"<p>In the situation we need to utilize the zimbra MySQL database server in order to host other databases, we may need to know what is the root password for MySQL. The following command will help you to find and display MySQL root password. These command has been tested on Zimbra 8.0.7 thas was running on CentOS 6.5 operating system.<\/p>\n<p>To view system operating system :<\/p>\n<pre>\n[root@mail-server ~]# cat \/etc\/redhat-release\nCentOS release 6.5 (Final)\n<\/pre>\n<p>To view zimbra version :<\/p>\n<pre>\n[root@mail-server ~]# su - zimbra\n[zimbra@mail-server ~]$ zmcontrol -v\nRelease 8.0.7_GA_6021.RHEL6_64_20140408123911 RHEL6_64 FOSS edition.\n<\/pre>\n<p>To view MySQL root password :<\/p>\n<pre>\n[root@mail-server ~]# su - zimbra\n[zimbra@mail-server ~]$ zmlocalconfig -s | grep mysql_root_password\nantispam_mysql_root_password =\nmysql_root_password = ipXlRAJ7654321FDXHb4nMUFr9Uf\n<\/pre>\n<p>To display zimbra MySQL pasword :<\/p>\n<pre>\n[root@mail-server ~]# su - zimbra\n[zimbra@mail-server ~]$ zmlocalconfig -s | grep mysql | grep password\nantispam_mysql_password =\nantispam_mysql_root_password =\nmysql_root_password = ipXlRAJ7654321FDXHb4nMUFr9Uf\nzimbra_mysql_password = c7dr5Tj7654321qcHCP6qJMVRVw\n<\/pre>\n<p>To view more options and help :<\/p>\n<pre>\n[root@mail-server ~]# su - zimbra\n[zimbra@mail-server ~]$ zmlocalconfig --help\nusage: zmlocalconfig [options] [args]\nwhere [options] are:\n -c,--config <arg>   File in which configuration is stored.\n -d,--default        Show default values for keys listed in [args].\n -e,--edit           Edit configuration file, changing keys and values\n                     specified. [args] is in key=value form.\n -f,--force          Allow editing of keys whose change is known to be\n                     potentially dangerous.\n -h,--help           Show this usage information.\n -i,--info           Show documentation for keys listed in [args].\n -l,--reload         Send a SOAP request to the server to reload its local\n                     config.\n -m,--format <\/arg><arg>   Show values in one of these formats: plain (default),\n                     xml, shell, export, nokey.\n -n,--changed        Show values for only those keys listed in [args] that\n                     have been changed from their defaults.\n -p,--path           Show which configuration file will be used.\n -q,--quiet          Suppress logging.\n -r,--random         Used with the edit option, sets specified key to\n                     random password string\n -s,--show           Force display of password strings.\n -u,--unset          Remove a configuration key.  If this is a key with\n                     compiled in defaults, set its value to the empty\n                     string.\n -x,--expand         Expand values.\n<\/arg><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>In the situation we need to utilize the zimbra MySQL database server in order to host other databases, we may need to know what is the root password for MySQL&#8230;.<\/p>\n","protected":false},"author":6,"featured_media":5151,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wds_primary_category":0,"footnotes":""},"categories":[1008,1100],"tags":[1322,1585,1946,1951,1953],"class_list":["post-5215","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-zimbra","tag-database","tag-mysql","tag-zimbra","tag-zimbra-collaboration-suite","tag-zimbra-mail-server"],"_links":{"self":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/5215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/comments?post=5215"}],"version-history":[{"count":0,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/5215\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media\/5151"}],"wp:attachment":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media?parent=5215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/categories?post=5215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/tags?post=5215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}