How to change the root password mysql zadmin?

[intertek]

Please who can help.
I have 46 sites that were located on another server and want aqgora pass them to the server with zpanelx 10 - windows 7.
Is working ok with many areas today.

These 46 sites are all wordpress and all use the same user and same password for all.
would be easier and safer for me to change the mysql root password zapanel than changing the wp-config file for each wordpress site.

In phpmyadmin I can simply change the root password of the user base zadmin_core without having server problems?

Can anyone help?

[tgates]

Why do you need root? You can't make another mysql user with the name and pass of the wp sites?

[intertek]

Why do you need root? You can't make another mysql user with the name and pass of the wp sites?

All sites are to root user in wp-config and would change a lot of work,
I prefer to change the password.

Is there way to change the password of root user?

[tgates]

OOO ok, duh...LOL Actually, I know of a program that can scan files and change the contents of them... It's call Advanced Find And Replace. I think the trial version works fully for 30 days... if you have a copy of all the sites on your local computer, you could scan for ="root" and have it replace it with ="newname".
This would be a better way since the root user is key to your system's security.

[intertek]

OOO ok, duh...LOL Actually, I know of a program that can scan files and change the contents of them... It's call Advanced Find And Replace. I think the trial version works fully for 30 days... if you have a copy of all the sites on your local computer, you could scan for ="root" and have it replace it with ="newname".
This would be a better way since the root user is key to your system's security.

Ok I do not want to change the name of the user "root",
I wanted to change the "password" the user "root" password only the user "root" that is created randomly on the installation zpanel

[tgates]

Ok, log into phpmyadmin as root user, under privileges select root user where password column says 'yes' (root localhost)
Another window will pop up, scroll down and you will see the part for changing password.
You will then need to edit '\zpanel\panel\cnf\db.php' and change the password there.
Also you need to edit '\zpanel\panel\cnf\db.inc.php'
You will more than likely need to change the password for your mail server, and possibly some other more places that need changing that I can't think of atm.

Although, I highly suggest using the advanced find and replace and make a totally separate database user account for them.

[itmanx]

On CentOS (and no doubt other linux distro's)

Changing MySQL root password
----------------------------
nano /etc/zpanel/panel/cnf/db.php
nano /etc/zpanel/configs/roundcube/db.inc.php
nano /etc/zpanel/panel/etc/apps/webmail/config/db.inc.php