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.

Automate creating MySQL database and users for cPanel account

Discussion in 'Database Discussions' 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,622
    Likes Received:
    25
    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
     
    #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. Tomas Naveiro

    Backup Automated

    Tomas Naveiro, Aug 1, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    85
    cPanelMichael
    Aug 2, 2017
  2. GoWilkes

    Automated emails from Perl script to Outlook and Gmail being discarded

    GoWilkes, Jul 21, 2017, in forum: E-mail Discussions
    Replies:
    13
    Views:
    159
    cPanelMichael
    Jul 27, 2017
  3. Sebastian Ng

    Automated email request and removal

    Sebastian Ng, May 2, 2017, in forum: cPanel Developers
    Replies:
    8
    Views:
    232
    Sebastian Ng
    Jun 3, 2017
  4. ugcoder

    How to automate WHM setup

    ugcoder, Apr 18, 2017, in forum: cPanel Developers
    Replies:
    1
    Views:
    250
    cPanelMichael
    Apr 18, 2017
  5. Jeff P.

    SOLVED Automated email generation script issue

    Jeff P., Nov 28, 2016, in forum: cPanel Developers
    Replies:
    3
    Views:
    446
    cPanelMichael
    Dec 12, 2016

Share This Page