Mobile app version of vmapp.org
Login or Join
Murray432

: Changing MySQL password in WHM When resetting an account password in WHM, I get a checkbox with this option: "Sync MySQL password with account password." If an account has multiple MySQL databases,

@Murray432

Posted in: #Cpanel #Mysql

When resetting an account password in WHM, I get a checkbox with this option: "Sync MySQL password with account password."

If an account has multiple MySQL databases, what password is it going to change?

I did a test on a WordPress site and noticed that the MySQL password did not change, so I'm curious as to what this setting does.

10.01% popularity Vote Up Vote Down


Login to follow query

More posts by @Murray432

1 Comments

Sorted by latest first Latest Oldest Best

 

@Sherry384

It is basically used to Update the cPanel User's Password to Restore Database Access. Internally it fires following:

/usr/local/cpanel/bin/restoregrants --cpuser=$cpuser --db={mysql, pg} --dbuser=$dbuser


or

/usr/local/cpanel/bin/restoregrants --cpuser=$cpuser --db={mysql, pg} --all


where,


$cpuser is cPanel username,
and
$dbuser is database user whose privileges you wish to restore.


Refer this for complete detail.

10% popularity Vote Up Vote Down


Back to top | Use Dark Theme