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.

mysql database no longer showing up in cpanel

Discussion in 'General Discussion' started by audrey, Jul 7, 2011.

  1. audrey

    audrey Well-Known Member

    Joined:
    Oct 18, 2006
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    8
    Hi

    This is a server wide issue

    after a server crash- mysql databases are no longer showing up in cpanel.

    When I click on the MySql icon in cpanel- I see no mysql users and no mysql databases
    but
    mysql databases still work perfectly on the sites

    in the whm phpmyadmin the databases show up

    in the cpanel phpmyadmin they do not show up

    Thanks for your help
    Audrey
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hi Audrey,

    Are you able to enter MySQL command line in root SSH?

    Code:
    mysql
    If you do without any errors, try to do the following to see if this resolves the issue:

    Code:
    /usr/local/cpanel/bin/setupdbmap
    If that does not work, please check /usr/local/cpanel/logs/error_log for any errors on trying to load the MySQL databases area in cPanel, then paste the error message(s) here.
     
  3. audrey

    audrey Well-Known Member

    Joined:
    Oct 18, 2006
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    8
    Hi Tristan

    I ran the ssh commands
    but it did not solve the problem
    databases still not showing up

    There are no database errors in the error logs

    Thanks
    Audrey
     
  4. audrey

    audrey Well-Known Member

    Joined:
    Oct 18, 2006
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    8
    Hi Tristan

    now I can see the database in cpanel phpmyadmin- but not in cpanel mysql area

    Thanks
    Audrey
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hi Audrey,

    Please open up a ticket at WHM > Support Center > Contact cPanel or using the link in my signature. Please post the ticket number here upon opening one.

    Thanks!
     
  6. audrey

    audrey Well-Known Member

    Joined:
    Oct 18, 2006
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    8
    Thanks Tristan
    I will do that
    Take Care
    Audrey
     
  7. audrey

    audrey Well-Known Member

    Joined:
    Oct 18, 2006
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    8
    Hi Tristan

    Here is the ticket number
    1722409

    Thanks Again
    Audrey
     
  8. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hi Audrey,

    I ran the command I mentioned earlier on the forum on your machine and the databases are showing up:

    Code:
    /usr/local/cpanel/bin/setupdbmap
    Before, the users weren't showing yaml files in /var/cpanel/databases area and that's why the mapping wasn't working to display the databases each owned in cPanel > MySQL Databases area.

    I've replied to your ticket with the above details as well.

    Thanks!
     
  9. audrey

    audrey Well-Known Member

    Joined:
    Oct 18, 2006
    Messages:
    72
    Likes Received:
    1
    Trophy Points:
    8
    Hi Tristan

    Outrageous!!

    You Rock!!!!!!!!!!!!!!!!!!!!!!

    Thanks a ton
    Audrey
     
Loading...

Share This Page