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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Command Line created DB not appearing in CPanel but is in phpMyAdmin

Discussion in 'Database Discussion' started by webnoob, Jun 3, 2011.

  1. webnoob

    webnoob Member

    Joined:
    Jun 3, 2011
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    51
    Hi All,

    I have done "CREATE DATABASE MYDB" via SSH and it appears in phpMyAdmin, however, when I go to the MySQL Databases section in CPanel, I cannot see it.

    I presume there is a file somewhere that needs appending. Can anyone explain what I need to do to make it show as I want other users to be able to delete / see the database is there should they need to.

    Many Thanks.
    webnoob.
     
    #1 webnoob, Jun 3, 2011
  2. Aleksl

    Aleksl Member
    PartnerNOC

    Joined:
    Jan 15, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    Hi

    Database must be created with prefix - cPanel login. Ex. - CREATE DATABASE login_db
    After this - run /usr/local/cpanel/bin/setupdbmap via SSH and database must appear in MySQL Databases section
     
    #2 Aleksl, Jun 9, 2011
  3. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,556
    Likes Received:
    41
    Trophy Points:
    308
    cPanel Access Level:
    Root Administrator
    #3 cPanelKenneth, Jun 9, 2011
(You must log in or sign up to post here.)
Loading...
Similar Threads - Command Line created
  1. ItsMattSon

    Command line /usr/local/bin/php and PHP-FPM

    ItsMattSon, Feb 24, 2018, in forum: General Discussion
    Replies:
    6
    Views:
    295
    cPanelMichael
    Feb 28, 2018
  2. albatroz

    Changing cPanel home folder from the command line

    albatroz, Dec 30, 2017, in forum: General Discussion
    Replies:
    1
    Views:
    178
    cPanelMichael
    Dec 30, 2017
  3. ameisez

    Unable to import database from ssh command line

    ameisez, Dec 11, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    231
    cPanelMichael
    Dec 11, 2017
  4. Felipe G

    SOLVED clamav command line install

    Felipe G, Dec 3, 2017, in forum: General Discussion
    Replies:
    2
    Views:
    426
    cPanelMichael
    Dec 4, 2017
  5. ottdev

    Command lines to provision and install main SSL?

    ottdev, Nov 22, 2017, in forum: Security
    Replies:
    7
    Views:
    430
    cPanelMichael
    Nov 29, 2017

Share This Page