Author Topic: Warning: mysqli_connect(): (HY000/2002)  (Read 164 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Warning: mysqli_connect(): (HY000/2002)
« on: June 07, 2019, 09:13:01 AM »
i have this problem
and i reset password and after restart all and same no worked !!!
Tnx very much

============

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:
« Last Edit: June 07, 2019, 09:56:48 AM by vinceent »

Offline
*
Re: Warning: mysqli_connect(): (HY000/2002)
« Reply #1 on: June 07, 2019, 10:24:57 AM »
[root@srv scripts]# ./checkdb
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory")

[root@srv init.d]# service mysqld restart
 ERROR! MariaDB server PID file could not be found!
Starting MariaDB.190607 14:15:23 mysqld_safe Logging to '/var/lib/mysql/srv.netlinkunix.eu.err'.
190607 14:15:23 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
.../etc/init.d/mysqld: line 264: kill: (328) - No such process
 ERROR!
 ERROR! Failed to restart server.
« Last Edit: June 07, 2019, 10:59:27 AM by vinceent »

Offline
*
Re: Warning: mysqli_connect(): (HY000/2002)
« Reply #2 on: June 07, 2019, 11:06:55 AM »
190607 14:23:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2019-06-07 14:23:05 140120395659296 [Note] /usr/sbin/mysqld (mysqld 10.1.40-MariaDB) starting as process 6262 ...
2019-06-07 14:23:05 140120395659296 [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.

2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: The InnoDB memory heap is disabled
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Using Linux native AIO
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Using SSE crc32 instructions
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Completed initialization of buffer pool
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Highest supported file format is Barracuda.
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: 128 rollback segment(s) are active.
2019-06-07 14:23:05 140120395659296 [Note] InnoDB: Waiting for purge to start
2019-06-07 14:23:05 140120395659296 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 17677359499
2019-06-07 14:23:05 140120395659296 [Note] Plugin 'FEEDBACK' is disabled.
2019-06-07 14:23:05 140120395659296 [Note] Recovering after a crash using tc.log
2019-06-07 14:23:05 140120395659296 [ERROR] Can't init tc log
2019-06-07 14:23:05 140120395659296 [ERROR] Aborting

190607 14:23:07 mysqld_safe mysqld from pid file /var/lib/mysql/srv.netlinkunix.eu.pid ended

Offline
*
Re: Warning: mysqli_connect(): (HY000/2002)
« Reply #3 on: June 07, 2019, 11:13:39 AM »
same error i have .. and try to solved but i can't :-(

Offline
*
Re: Warning: mysqli_connect(): (HY000/2002)
« Reply #4 on: June 07, 2019, 11:46:28 AM »
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 !!!