Control Web Panel
WebPanel => MySQL => Topic started 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:
-
i have the same error
on /var/lib/mysql i have no mysql.sock
when i use putty
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")
-
have the same issue ...
Just occured out of nowhere this morning
Any soilutions as my client has no db backup
-
please try to execute this script and tell me how it went
sh /scripts/mysql_pwd_reset
-
deleted the socket file :
rm -vf /var/lib/mysql/mysql.sock
Then I was getting errors at mysql startup :
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.
[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 :
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
-
same i have error now and i don't now how to solved this !!! can to tell me ? Tnx very much
-
i delete in "
/etc/var/lib/mysql .
rm -rf . rm -rf tc.log
after i restart mysql
service mysqld restart
Shutting down MariaDB.. SUCCESS!
and after in .
cd /scripts/
./image_rebuild_server_config
and all is ok !!!
-
i delete in "
/etc/var/lib/mysql .
rm -rf . rm -rf tc.log
after i restart mysql
service mysqld restart
Shutting down MariaDB.. SUCCESS!
It's the worst way I saw xD
-
I have the same error ,can someone guide us how to fix it, please.
-
I have the same error ,can someone guide us how to fix it, please.
Just ask to see a competent sysadmin. Sometimes can help deleting /var/lib/mysql/ib_logfile0 and /var/lib/mysql/ib_logfile1, sometimes can't and must be investigated.