SQLSTATE [HY000] [2002] Can not connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")

0

A few hours ago mysql started to fall on my server. Restarted and hung up after a while. Now I can not even lift it, I get the error:

  

SQLSTATE [HY000] [2002] Can not connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111 "Connection refused")

Help please !!!

Using CentOS7, it's the first time this happens to me. The server has been online for more than a year. I have about 5 or 6 web portals dropped. Please help :(

I have enough space on the hard drive, more than 20GB available in the OS partition and more than 1TB in the data partition

    ● mariadb.service - MariaDB database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
       └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Wed 2018-07-04 15:10:02 CEST; 36s ago
   Process: 12957 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
   Process: 12945 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR='/usr/bin/galera_recovery'; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
   Process: 12943 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
   Main PID: 12957 (code=exited, status=1/FAILURE)
   CGroup: /system.slice/mariadb.service

    my_host mysqld[12957]: /usr/sbin/mysqld(+0x414cd6)[0x556d3671ccd6]
    my_host mysqld[12957]: /usr/sbin/mysqld(+0x93a7ce)[0x556d36c427ce]
    my_host mysqld[12957]: /usr/sbin/mysqld(+0x93adf2)[0x556d36c42df2]
    my_host mysqld[12957]: /usr/sbin/mysqld(+0x93e2b8)[0x556d36c462b8]
    my_host mysqld[12957]: /usr/sbin/mysqld(+0x914ce5)[0x556d36c1cce5]
    my_host mysqld[12957]: /lib64/libpthread.so.0(+0x7dc5)[0x7f113e774dc5]
    my_host systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
    my_host systemd[1]: Failed to start MariaDB database server.
    my_host systemd[1]: Unit mariadb.service entered failed state.
    my_host systemd[1]: mariadb.service failed.
    
asked by ramon lopez 04.07.2018 в 12:17
source

0 answers