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 is offline

Discussion in 'Database Discussions' started by seahorse, Feb 20, 2012.

  1. seahorse

    seahorse Well-Known Member

    Joined:
    Jul 3, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    Last week i've successfully created a database through cpanel.

    This week when i login into cpanel intend to create another database, click on the MySQL Databases, it is now telling me "The MySQL® server is currently offline."

    - i've checked the database process with (ps -aux), it is there.
    - i can go into phpmyadmin.
    - the site using the database is working.
    - ssh with root, mysqladmin proc is showing the process list.

    i've tried the following from advice from other related threads.

    - reset root mysql password
    - restart mysql service
    - tried /scripts/checkperlmodules --full --force
    - tried /scripts/upcp --force

    still does not work


    WHM 11.30.5 (build 3)
    /usr/local/cpanel/logs/error_log


    Basically, the database server is still running and existing database is working with existing site, but i am not able to create database from cpanel. It is showing "The MySQL Server is offline".

    Can anyone provide me some advise?
     
    #1 seahorse, Feb 20, 2012
    Last edited: Feb 20, 2012
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,472
    Likes Received:
    200
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Using the x3 theme correct? I'd suggest you open a ticket to cPanel Support for a closer look. From in your WHM find the Support menu top right corner of every page, click Contact cPanel.
     
  3. seahorse

    seahorse Well-Known Member

    Joined:
    Jul 3, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    yes i am using x3 theme..
    is there anything i can do on my side before requesting support ?
    it is rather weird that i can do it last week but suddenly cant do it now.
     
  4. 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
    In root SSH, you can type mysql and connect into MySQL command line, correct? If you can, please provide the output when using this command in root SSH:

    Code:
    mysql -u root -p
    You'd need to enter the password found in /root/.my.cnf location for the password.
     
  5. seahorse

    seahorse Well-Known Member

    Joined:
    Jul 3, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    i've run the command "mysql -u root -p" at root ssh with the password at "/root/.my.cnf"
    i successfully went into mysql mode.

    At the moment, the cpanel -> mysql database is still "The MySQL® server is currently offline."

     
  6. 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
    You are going to have to open up a ticket, since MySQL is functioning and you can enter as root user into MySQL. There's a link in my signature to submit a ticket or you could use WHM > Support Center > Contact cPanel to do so. We can track the resolution if you post the ticket number here after you've opened it. Thanks!
     
  7. seahorse

    seahorse Well-Known Member

    Joined:
    Jul 3, 2003
    Messages:
    49
    Likes Received:
    0
    Trophy Points:
    6
    i was using the release build. i've decided to upgrade to current build and it fixed the issue.
    most likely is the problem of cpanel which somehow not using the root mysql password at "/root/.my.cnf" to interact with mysql server.
     
  8. TechShogun

    TechShogun Registered

    Joined:
    Feb 26, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    You probably have a bad configuration in /etc/my.cnf. Try changing the root password as follows:

    Code:
    mysqladmin -u root password NEWPASSWORD
    If this is the case, you would most likely get something "similar" to:

    If you do, try commenting out the defective line in /etc/my.cnf

    Cheers!
     
Loading...

Share This Page