Mapping MySQL user permissions via command line? (/cpanel/bin/?)

[Kadence]

If a database and user are created outside of cPanel, you call map them to cPanel dbmaptool; for instance for account "acct1", database "acct1_db1" and user "acct1_user1":

/usr/local/cpanel/bin/dbmaptool acct1 --type mysql --dbs 'acct1_db1' --dbusers 'acct1_user1'

This tells cPanel that acc1_db1 exists, and that acct1_user1 exists.

However, this does not tell cPanel whether acct1_user1 has permissions for the database acct1_db1.

How do you tell cPanel about user permissions via the command line?

 

[cPanelMichael]

Hello

You would have to utilize our API to grant a database user permissions to a database, as referenced in the following post:

Database User Permissions

Thank you.