: 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,
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.
More posts by @Murray432
1 Comments
Sorted by latest first Latest Oldest Best
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.
Terms of Use Create Support ticket Your support tickets Stock Market News! © vmapp.org2024 All Rights reserved.