Author Topic: problem with start Mysql  (Read 32827 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
problem with start Mysql
« 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
« Last Edit: January 08, 2017, 11:32:35 AM by vinceent »

Offline
*
Re: problem with start Mysql
« Reply #1 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


Offline
**
Re: problem with start Mysql
« Reply #2 on: January 24, 2017, 10:10: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


Offline
*
Re: problem with start Mysql
« Reply #3 on: July 03, 2017, 11:18:34 AM »
Finally after reading a lot, this tc.log removed is worked.

And started mysql services.

Offline
*
Re: problem with start Mysql
« Reply #4 on: June 07, 2019, 11:17:22 AM »
I can't solve this problem with deleting and restarting. do you have any other suggestion?

Offline
*
Re: problem with start Mysql
« Reply #5 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:

Offline
*****
Re: problem with start Mysql
« Reply #6 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.
You can ask me to solve any problem with your server for some money in pm  ;)
Services Monitoring & RBL Monitoring
http://centos-webpanel.com/services-monitor
Join our Development Team and get paid !
http://centos-webpanel.com/develope-modules-for-cwp

Installation Instructions
http://centos-webpanel.com/installation-instructions
Get Fast Support Here
http://centos-webpanel.com/support-services

Offline
*
Re: problem with start Mysql
« Reply #7 on: November 01, 2019, 08:41:01 AM »
May be your disk is full.

Offline
*
Re: problem with start Mysql
« Reply #8 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:

Offline
*
Re: problem with start Mysql
« Reply #9 on: February 16, 2023, 02:04:10 AM »
Try this command using ssh terminal:
/scripts/mysql_pwd_reset -q

Offline
****
Re: problem with start Mysql
« Reply #10 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