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.

The MySQL server is currently offline.

Discussion in 'Database Discussions' 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:
    30,675
    Likes Received:
    648
    Trophy Points:
    113
    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.
     
  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:
    30,675
    Likes Received:
    648
    Trophy Points:
    113
    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.
     
  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:
    30,675
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page