Jump to content

[Solved] MySQL Server offline?


Recommended Posts

Posted (edited)

Hey everybody,

 

I'm quite new to this. I signed up yesterday to Johnny and started to send some data to a MySQL database. That worked quite good but since 3.5 hours the server seems not accessible and in the cpanel I get a message that the server is down.

 

The MySQL server is currently offline.

Error while connecting to MySQL: (XID 8f868x) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) Error while connecting to MySQL: (XID 8f868x) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1.

 

 

Is there something wrong in my application posting the data or is the server really down?

 

I'm quite confused...

 

Thomas

Edited by zwerggwi
  • Like 1
Link to comment
Share on other sites

Hello, I was trying to add a MySQL Database on Johnny, and when I click the MySQL Database button on cPanel, it shows the errors:

 

 

The MySQL server is currently offline.

Error while connecting to MySQL: (XID 7etnka) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) Error while connecting to MySQL: (XID 7etnka) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1.

 

Did anyone have this error too on Johnny?

 

Thanks in advance, Leo.

Link to comment
Share on other sites

Pause for a while and try again, it could be high load. Meanwhile, someone already made a post about it. I guess it will be attend to with a immediate effect

Link to comment
Share on other sites

Posted (edited)

Sorry to say, but no. Johnny's MySQL is offline again... (07:46 AM CET)

 

[Edit] Back online again. (8:31 AM CET)

 

Off again since 01:00 PM CET

Edited by zwerggwi
Link to comment
Share on other sites

The MySQL server is currently offline.

Error while connecting to MySQL: (XID xy4zpq) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) Error while connecting to MySQL: (XID xy4zpq) The system failed to connect to the “MySQL” database “mysql” because of an error: CR_CONNECTION_ERROR (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)) at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Similar Content

    • By phantomg
      I am unable to download my backup files from johnny server help!!
    • By infinit5
      Hi,

      i'm using Johnny Heliohost remote mysql and codeigniter 4 for development. After a few requests from the frontend, I'm seeing this error on mysql that user has more than max_user_connections (code 1203). While connecting db from backend, codeigniter seems to automatically close db connections. Even when I'm checking through workbench show processlist shows only 1 sleeping process. But then, suddenly max_user_connections exceeds the limit for the same request which was working a moment before.

      So, my asks are jotted below:
      - Can the mysql wait_timeout parameter be redued to 180 secs?
      - From mysql documentation it seems the max_user_connections are set to 150 and another for super user, is there any additional limit from heliohost's end?

      If there's any better way of dealing with this problem I'm all ears.

      regards
      inifinit5
    • By 7eter
      I wanted to switch to Johnny if that's still possible.
      I made a donation via PayPal ID: 296783309L762123Y.
      My original account is on Ricky and username was 7eter (i believe). Email has always been peteramried@web.de
      Thank you!
       
    • By robertzo
      I'm asking about the difference between production servers and testing servers. I heard that uptime is a factor, but is there any other factors that makes one better. I also heard that the speed is faster, but also heard that Ricky was slow (before the upgrading). Also this is off topic but is Autossl Let's Encrypt or Sectigo/Comondo (I know that cpanel.net is Sectigo)???
    • By robertzo
      I have a question?
       
      What is the difference between Johnny and Ricky? Does Ricky cost money? Which one is worth it and what is the tradeoff? 
×
×
  • Create New...