Control Web Panel

WebPanel => MySQL => Topic started by: vinceent on January 07, 2017, 11:56:51 PM

Title: problem with start Mysql
Post by: vinceent on January 07, 2017, 11:56:51 PM

Hi all i have a install after 8 months a cwp and worked perfect but in this night i try to login in cwp pannel and my password is not worked ... i reboot my server and now i recive this error :

Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

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

Could not connect: No such file or directory

and i specific: in /root/.my.cnf and /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php is same password !!!

AND I HAVE THIS VERSION:  mysql  Ver 15.1 Distrib 10.1.20-MariaDB, for Linux (x86_64) using readline 5.1


i try to restart mysqld manualy and recive :
[root@srv ~]# service mysqld start
Starting MySQL.170108 01:58:56 mysqld_safe Logging to '/var/lib/mysql/srv.netlinkunix.eu.err'.
.. ERROR!

and in /var/lib/mysql/srv.netlinkunix.eu.err     have this :
170108 02:00:28 mysqld_safe mysqld from pid file /var/lib/mysql/srv.netlinkunix.eu.pid ended
170108 02:00:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-01-08  2:00:34 139957175629856 [Note] /usr/sbin/mysqld (mysqld 10.1.20-MariaDB) starting as process 16418 ...
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: The InnoDB memory heap is disabled
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Using Linux native AIO
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Using SSE crc32 instructions
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Completed initialization of buffer pool
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Highest supported file format is Barracuda.
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: 128 rollback segment(s) are active.
2017-01-08  2:00:34 139957175629856 [Note] InnoDB: Waiting for purge to start
2017-01-08  2:00:34 139957175629856 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1$
2017-01-08  2:00:34 139957175629856 [Note] Plugin 'FEEDBACK' is disabled.
2017-01-08  2:00:34 139957175629856 [Note] Recovering after a crash using tc.log
2017-01-08  2:00:34 139957175629856 [ERROR] Can't init tc log
2017-01-08  2:00:34 139957175629856 [ERROR] Aborting




I need help to solved this problem !!!


Tnx

Title: Re: problem with start Mysql
Post by: vinceent on January 08, 2017, 11:40:09 AM

SOLVED !!!!

cd /var/lib/mysql/
and after delete this:  rm -rf tc.log
after:  service mysqld restart

Title: Re: problem with start Mysql
Post by: robbyq on January 24, 2017, 10:10:09 AM

Quote from: vinceent on January 08, 2017, 11:40:09 AM

SOLVED !!!!

cd /var/lib/mysql/
and after delete this:  rm -rf tc.log
after:  service mysqld restart

i am same error

Code: [Select]

Warning: [obfuscated](): No such file or directory in /usr/local/cwpsrv/htdocs/admin/index.php on line 0
SUCCESS! MySQL running (27041)

Trying to start mysql server, please wait!
Try to restart CentOS Web Panel with command: service cwpsrv restart

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

Could not connect: No such file or directory

Title: Re: problem with start Mysql
Post by: vpulshah on July 03, 2017, 11:18:34 AM

Finally after reading a lot, this tc.log removed is worked.

And started mysql services.

Title: Re: problem with start Mysql
Post by: burakimrek on June 07, 2019, 11:17:22 AM

I can't solve this problem with deleting and restarting. do you have any other suggestion?

Title: Re: problem with start Mysql
Post by: vinceent on June 07, 2019, 11:37:11 AM

now i have this problem and can't find one solution

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: problem with start Mysql
Post by: Igor S. on June 28, 2019, 08:39:50 AM

You must check why you are not able to start MySQl/MariaDB server and fix the reason.
Then ask somebody to help you and start it.

Title: Re: problem with start Mysql
Post by: pradiptac on November 01, 2019, 08:41:01 AM

May be your disk is full.

Title: Re: problem with start Mysql
Post by: itroncoso on November 06, 2019, 12:41:26 PM

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: problem with start Mysql
Post by: hyochan_09 on February 16, 2023, 02:04:10 AM

Try this command using ssh terminal:
/scripts/mysql_pwd_reset -q

Title: Re: problem with start Mysql
Post by: overseer on March 04, 2023, 09:55:16 PM

Unless something changed recently, the Reset MySQL Root Password script was woefully out of date. Change it manually on the command line and check the 2 referenced files to make sure they agree with the newly reset password:

Code: [Select]

/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
/root/.my.cnf