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

Kadence

• August 29, 2014 07:33

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

  • August 29, 2014 14:39

  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.

  0

Please sign in to leave a comment.