Tell me more ×
Webmasters Stack Exchange is a question and answer site for pro webmasters. It's 100% free, no registration required.
up vote 1 down vote favorite

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.

share|improve this question

1 Answer

up vote 2 down vote accepted

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.

share|improve this answer
Excellent. Thank you! – TechWire Feb 1 at 14:26
Hmmm...given your answer, under what circumstance would you choose NOT to sync the passwords? – TechWire Feb 1 at 14:33
Webmasters choose to sync for restoring database access otherwise not. Its a recovery measure. – sundeep Feb 3 at 14:42

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.