Valid for versions 82 through the latest version
Last modified: May 13, 2020
Overview
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:
/usr/local/cpanel/bin/dbstoregrants username
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