CentOS Web Panel

WebPanel => MySQL => Topic started by: BeReal on March 11, 2018, 12:47:14 PM

Title: Warning: mysqli_connect(): (HY000/2002)
Post by: BeReal on March 11, 2018, 12:47:14 PM
I have not made any changes myself as a user on the VDS server. I was using PHP versions 5.2 and 5.6 due to the scripters I used.

everything was normal and suddenly I started to get this error. the server company can not help. I have to recover the latest updated database backup.  Thank you from now.

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): No such file or directory in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0


Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: sh /scripts/restart_cwpsrv

**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:
Title: Re: Warning: mysqli_connect(): (HY000/2002)
Post by: ecoll on May 27, 2018, 08:53:01 PM
i have the same error

on /var/lib/mysql i have no mysql.sock

when i use putty
Code: [Select]
mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")
Title: Re: Warning: mysqli_connect(): (HY000/2002)
Post by: minetcalin on June 21, 2018, 01:35:15 AM
have the same issue  ...
Just occured out of nowhere this morning

Any soilutions as my client has no db backup
Title: Re: Warning: mysqli_connect(): (HY000/2002)
Post by: josemnunez on June 21, 2018, 12:35:27 PM
please try to execute this script and tell me how it went

Code: [Select]
sh /scripts/mysql_pwd_reset
Title: Re: Warning: mysqli_connect(): (HY000/2002)
Post by: minetcalin on June 27, 2018, 01:24:28 AM
deleted the socket file :
Code: [Select]
rm -vf /var/lib/mysql/mysql.sockThen I was getting errors at mysql startup :
Quote
2018-06-26 18:08:55 140082288351264 [Note] /usr/sbin/mysqld (mysqld 10.1.26-MariaDB) starting as process 1706 ...
2018-06-26 18:08:55 140082288351264 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.
Code: [Select]
[root@vps***** ~]# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sda1       9.8G  9.3G   19M 100% /
tmpfs           915M     0  915M   0% /dev/shm
So partition is full : deleted quite a bit. Restarted server
restart mysql : getting different error :
Quote
2018-06-26 18:15:26 140368591808544 [ERROR] Can't init tc log
2018-06-26 18:15:26 140368591808544 [ERROR] Aborting
Deleted tc.log
rebooted server : mysql is running, and new tc.log file created

Basically, disk full and could not write to tc.log