The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by Kadence, Aug 29, 2014.

  1. Kadence

    Kadence Member

    Joined:
    Nov 25, 2006
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    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":
    Code:
    /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?
     
    #1 Kadence, Aug 29, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    34,831
    Likes Received:
    1,058
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
    #2 cPanelMichael, Aug 29, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - Mapping MySQL user
  1. linux-tech

    database mapping

    linux-tech, Jul 29, 2016, in forum: Database Discussions
    Replies:
    1
    Views:
    326
    cPanelMichael
    Jul 29, 2016
  2. Anoop P Alias

    New Thread restartsrv mysql doing things it should not

    Anoop P Alias, May 20, 2017 at 10:14 PM, in forum: cPanel Developers
    Replies:
    0
    Views:
    29
    Anoop P Alias
    May 20, 2017 at 10:14 PM
  3. equens

    New Thread pymysql python module not installed

    equens, May 20, 2017 at 7:08 AM, in forum: Database Discussions
    Replies:
    1
    Views:
    25
    RadWebHosting
    May 20, 2017 at 8:23 AM
  4. Milance

    New Thread pdo_mysql skipped as conflicting

    Milance, May 20, 2017 at 1:26 AM, in forum: General Discussion
    Replies:
    2
    Views:
    33
    Milance
    May 20, 2017 at 5:19 AM
  5. akash7130

    Import database in mysql?

    akash7130, May 19, 2017 at 10:31 PM, in forum: Database Discussions
    Replies:
    1
    Views:
    33
    cPanelMichael
    May 22, 2017 at 10:37 AM

Share This Page