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!

Connection refusedFailed to connect to MySQL

Discussion in 'Database Discussion' started by conductexam, Aug 9, 2018.

  1. conductexam

    conductexam Member

    Joined:
    Aug 9, 2018
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    rajkot
    cPanel Access Level:
    Root Administrator
    Hello ,

    Last some days i am facing big issue ,

    Every hour i get mysql mail from demon ,

    1) Failed to connect to MySQL: Connection refused

    2) Failed to connect to MySQL: Connection refusedFailed to connect to MySQL: Connection refusedFailed to connect to MySQL: Connection refusedFailed to connect to MySQL: Connection refused

    3) The service “mysql” appears to be down.
    - XID hcx77f) The service “mysql” failed to start with the message: Lost connection to MySQL server at 'handshake: reading inital communication packet', system error: 104

    The subprocess “/usr/local/cpanel/scripts/restartsrv_mysql” reported error number 255 when it ended.

    4) cpanel-dovecot-solr
    - The service “cpanel-dovecot-solr” is now operational.


    Mysql take high process every time . Then mysql refuse connection .

    How to solve this .
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,204
    Likes Received:
    228
    Trophy Points:
    173
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hello @conductexam

    Can you let us know if there are any related errors in the mysql error log?


    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. conductexam

    conductexam Member

    Joined:
    Aug 9, 2018
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    rajkot
    cPanel Access Level:
    Root Administrator
    Hello ,
    Thank you for replying .

    There are no error_log .

    but i send you sent mail error ,

    [Removed Output - Link destinations included real domain names and email addresses]
     
  4. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,204
    Likes Received:
    228
    Trophy Points:
    173
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Can you please open a ticket using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved.


    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. conductexam

    conductexam Member

    Joined:
    Aug 9, 2018
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    rajkot
    cPanel Access Level:
    Root Administrator
    Hello ,

    From which location i get error_log, which you need.

    Please, help me.
     
  6. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,204
    Likes Received:
    228
    Trophy Points:
    173
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    the log location for mysql error logs is identified in /etc/my.cnf. The line as follows should tell you where the error log is in my case it's /var/log/mysqld.log:

    Code:
    log-error=/var/log/mysqld.log
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. conductexam

    conductexam Member

    Joined:
    Aug 9, 2018
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    rajkot
    cPanel Access Level:
    Root Administrator
    Hello ,

    My Support Request ID is: 10106633
     
  8. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,204
    Likes Received:
    228
    Trophy Points:
    173
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hello,

    Thank you for the update, I'm watching that ticket and I'll update this thread with the outcome when available.


    Thanks!
     
    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