Results 1 to 7 of 7

Thread: Nothing can connect to MySQL database!

  1. #1
    Registered User
    Join Date
    May 2012
    Posts
    1
    cPanel Access Level

    Root Administrator

    Unhappy Nothing can connect to MySQL database!

    I tried to import a MySQL dump into my WHM phpmyadmin tonight and it's caused all of the sites on my server to fail at connecting to their databases, so they're all down.

    The databases imported but have no tables in them, it didn't seem to have overwritten any of the existing tables as those all still have their data.

    There doesn't seem to be anything in the error log but this:

    cphulkd rejected registration attempt for cpaneld with: 400 Unable to connect to database backend: Failed to connect to mysql db: cphulkd

    I've checked my.cnf and it just had this:

    [mysqld]
    innodb_file_per_table=1

    So I stopped MySQL and changed it to this:

    [mysqld]
    port=3306
    socket=/tmp/mysql.sock
    innodb_file_per_table=1
    [client]
    port=3306
    socket=/tmp/mysql.sock

    Started MySQL and still the same. I'm running a graceful server reboot now, if anyone has a clue what else I could try please help me.

    Already put through a paid support ticket on #2720998.

    UPDATE: Graceful reboot didn't help.

    UPDATE: Running MySQL 5.1, should I update to 5.5? It's possible the import came from a 5.5 installation but I can't verify that.
    Last edited by stevebrewer; 05-29-2012 at 03:21 PM.

  2. #2
    Registered Member
    Join Date
    Jan 2004
    Posts
    173

    Default Re: Nothing can connect to MySQL database!

    I am having the same problem. Did you resolve this issue? How?

  3. #3
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel Access Level

    Root Administrator

    Default Re: Nothing can connect to MySQL database!

    You should likely disable cPHulk Brute Force Protection if it is causing the failure message to see if you can then connect. You can disable cPHulk in WHM > cPHulk Brute Force Protection area.

    If you cannot log into WHM due to the failures, then you can disable and stop it on the backend using the following:

    Code:
    /usr/local/cpanel/bin/cphulk_pam_ctl --disable
    for i in `ps aux | grep -i cphulk | grep -v grep | awk {'print $2'}` ;do kill $i ;done
    If MySQL is then working properly at that point, then please submit a ticket for us to investigate further.
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  4. #4
    Registered Member
    Join Date
    Jan 2004
    Posts
    173

    Default Re: Nothing can connect to MySQL database!

    Brute Force was not enabled. I also turned off the CSF firewall and same results. Very strange.

  5. #5
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel Access Level

    Root Administrator

    Default Re: Nothing can connect to MySQL database!

    Have you submitted a ticket? If so, please provide the ticket number here for tracking purposes. Thanks!
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

  6. #6
    Registered Member
    Join Date
    Jan 2004
    Posts
    173

    Default Re: Nothing can connect to MySQL database!

    Tristan, our Request id is: 3011958

  7. #7
    cPanel Staff cPanelTristan's Avatar
    Join Date
    Oct 2010
    Location
    somewhere over the rainbow
    Posts
    7,611
    cPanel Access Level

    Root Administrator

    Default Re: Nothing can connect to MySQL database!

    Hello,

    It appears we are still waiting for login credentials to WHM for the issue. The key you provided for connecting is a private key rather than public and requires a passphrase. We need that passphrase as well.

    Thanks!
    cPResources: Support Options | More Support Options | Forums Search | cPanel.net Site Search | Mailing Lists(Alt) | Docs
    -- Tristan, Technical Analyst III, Forums Specialist, cPanel Tech Support

    Submit a ticket | Check an existing ticket

Similar Threads

  1. Unable to connect to mysql database
    By upsforum in forum Security
    Replies: 14
    Last Post: 07-21-2014, 03:40 PM
  2. Replies: 6
    Last Post: 12-21-2010, 12:19 PM
  3. cphulkd can't connect to MySQL database
    By sehh in forum General Discussion
    Replies: 3
    Last Post: 08-20-2009, 08:57 AM
  4. Replies: 2
    Last Post: 06-22-2009, 08:30 AM
  5. Cannot connect to MySql Database using Dreamweaver
    By Ormus in forum Database Discussions
    Replies: 1
    Last Post: 02-18-2008, 04:58 AM
bargain