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!

The MySQL server is currently offline.

Discussion in 'Database Discussion' started by toriqulislam, Jun 2, 2014.

  1. toriqulislam

    toriqulislam Member

    Joined:
    Jun 2, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    I tried to find solution here in the forums but can't find it. If there is any thread that can help please give me link if not then please help me.

    I'm facing problem when i reset MySQL root password from WHM in cPanel.
    When i clicked on "MySQL® Databases" in Database section in cPanel it showing me this messages.
    I want to mention another thing that our database are Remote Database.

     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,943
    Likes Received:
    1,819
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please let us know the output in your MySQL error log (/var/lib/mysql/$hostname.err) when you restart MySQL or when you attempt to view the databases in cPanel.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. toriqulislam

    toriqulislam Member

    Joined:
    Jun 2, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi
    This error showing

    -bash: /var/lib/mysql/$hostname: No such file or directory

    I replaced hostname with my hostname.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,943
    Likes Received:
    1,819
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You have to use a command such as "tail" or "cat" to review a log file. EX:

    Code:
    tail -f /var/lib/mysql/$hostname
    Note that with a limited experience on the command line, you may want to consider consulting with a qualified system administrator or opening a support ticket so we can take a closer look. Remember to post the ticket number here should you decide to open a ticket.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. toriqulislam

    toriqulislam Member

    Joined:
    Jun 2, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Thanks for your response i was able to solve it by get a help from a friend. He just reset it via SSH. Now it's working again.
    Thanks.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,943
    Likes Received:
    1,819
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    I am happy to see the issue is now resolved. Thank you for updating us with the outcome.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice