Databáze řešení

The dbstoregrants Script  Tisknout tento článek

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
Note:
In this example, username represents the user for whom you wish to synchronize the MySQL grants changes.

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

Byla tato odpověď nápomocná?

Související články

WHM Scripts
Overview: The cPanel & WHM installation process adds important scripts to your server’s...
The dbmaptool Script
Overview: You can use the /usr/local/cpanel/bin/dbmaptool script to grant ownership of databases...
The servers_queue Script
Overview: This script allows you to manage the task queue system. The task queue system allows...
The auto-adjust-mysql-limits Script
Overview: The /usr/local/cpanel/scripts/auto-adjust-mysql-limits script updates MySQL®...
The autossl_check Script
Overview: The /usr/local/cpanel/bin/autossl_check script allows you to manually check the SSL...