The dbstoregrants Script
Valid for versions 82 through the latest version
Last modified: October 7, 2019
Sometimes, you must make changes directly to a MySQL® user’s grants in the YAML and JSON files in the
/var/cpanel/databases/ directory through the command line. Use the
/usr/local/cpanel/bin/dbstoregrants script to synchronize changes to those grants.
This will ensure that cPanel & WHM contains changes that you make on the command line.
Call the script
To run this script at the command line, run the following command as the root user:
To run this script for all cPanel users, run the following command as the root user:
for i in `ls -I \. -I \.\. -A /var/cpanel/users` ; do /usr/local/cpanel/bin/dbstoregrants $i ; done