Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Automate creating MySQL database and users for cPanel account

Discussion in 'Database Discussion' started by BraenDead, Feb 23, 2011.

  1. BraenDead

    BraenDead Member

    Joined:
    Dec 8, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    Is there a way to automate creating databases and users in MySQL for a particular cPanel account? I can create the database and user in MySQL automatically, but then they do not show up in the list of databases for the user in cPanel. I beleive it has to do with updating the files in /var/cpanel/databases, although there may be other things that need to be set as well. Anyways, if there are any scripts or API's to handle this, that would help tremendously.

    Thanks,

    Bob
     
    #1 BraenDead, Feb 23, 2011
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,608
    Likes Received:
    33
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello Bob,

    You can always try running /usr/local/cpanel/bin/dbmaptool to setup the mapping for the database to have it properly added to /var/cpanel/databases area, although I do suggest using the APIs instead if possible. You can get the options for /usr/local/cpanel/bin/dbmaptool by running the command without any parameters:

    The API for MySQL is at the following location:

    ApiMysql < ApiDocs/Api1 < TWiki

    There are additional discussions on using the APIs for database mapping at these locations:

    http://forums.cpanel.net/f42/case-45836-cpanel-api-not-adding-created-user-created-database-182011.html
    More Details About DB Mapping - cPanel Integration
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelTristan, Feb 23, 2011
  3. BraenDead

    BraenDead Member

    Joined:
    Dec 8, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    I tried using the API and was able to access other tools, but the Mysql::adddb api does not seem to work for me. Anyways - I created a post in the developer forum for this. Thanks for the info.

    Bob
     
    #3 BraenDead, Feb 23, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Automate creating MySQL
  1. stormthefront

    Automated fetching of license status

    stormthefront, May 28, 2018, in forum: General Discussion
    Replies:
    4
    Views:
    178
    stormthefront
    May 29, 2018
  2. PCZero

    Automate Security Advisor Script?

    PCZero, Apr 24, 2018, in forum: Security
    Replies:
    1
    Views:
    209
    cPanelLauren
    Apr 25, 2018
  3. schwim

    Automated backup solution option for Reseller?

    schwim, Dec 16, 2017, in forum: Data Protection
    Replies:
    20
    Views:
    1,093
    schwim
    Mar 21, 2018
  4. hanifeoglu

    Automated Backup Not Working Properly

    hanifeoglu, Nov 19, 2017, in forum: Data Protection
    Replies:
    2
    Views:
    416
    cPanelMichael
    Nov 20, 2017
  5. Tomas Naveiro

    Backup Automated

    Tomas Naveiro, Aug 1, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    570
    cPanelMichael
    Aug 2, 2017

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice