root initial password for mysql?

[Fabio]

Hello Sirs,
I would like to know what root initial password is attributed to the mysql database, thanks in advanced for your help.

Fabio

[DGS_David]

If you are logged in as zimbra then there is no password,

so, log in as root and type:

% su - zimbra
% mysql
% show databases ;
...

Does that help?

David

[Fabio]

Hello David,
it's true, thanks for your answer.

Fabio

[dijichi2]

although the zimbra user is setup to run the cli client without a password, mysql does have a root password that you need to use for anything else, e.g. phpmyadmin. look in /opt/zimbra/conf/localconfig.xml and look for mysql_root_password.

[DGS_David]

Thanks for clarifying that. If Fabio had changed the password it would have broken other access routes using this config. Phew...

D.

[Fabio]

Hello Sirs,
thanks for your help, I had already resolved my problem for the change of password using the script zmmypasswd, that uses standard commands mysql and the command zmlocalconfig to modify the inside variable of Zimbra (tomcat) as for the note mysql_root_password.
Now I can use PhpMyAdmin to operate more easily on the database mysql.
However thanks to your help I have finally discovered whether to find the values of these variable (/ opt/zimbra/conf/localconfig.xml).

Fabio