Author Topic: Trying to start mysql server, please wait! help!!!!!  (Read 5472 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Trying to start mysql server, please wait! help!!!!!
« on: June 05, 2020, 04:24:19 AM »

Hello, I was deleting some folders, and suddenly the site stopped working and appears when entering the panel:

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: Trying to start mysql server, please wait! help!!!!!
« Reply #1 on: June 05, 2020, 04:28:49 AM »
What were you deleting??

Manual Reinstall the files with the following:

Code: [Select]
chattr -i -R /usr/local/cwpsrv/htdocs
cd /usr/local/cwpsrv/htdocs
wget static.cdn-cwp.com/files/cwp/el7/cwp-el7-0.9.8.961.zip
unzip -o -q cwp-el7-0.9.8.961.zip
rm -f cwp-el7-0.9.8.961.zip
```

**Manual update CentOS 6 (ignore if you have CentOS 7)**
```
chattr -i -R /usr/local/cwpsrv/htdocs
cd /usr/local/cwpsrv/htdocs
wget dl1.centos-webpanel.com/files/cwp/cwp2-0.9.8.765.zip
unzip -o cwp2-0.9.8.765.zip
rm -f cwp2-0.9.8.765.zip
```


**Manual update for services (This steep must be done for CentOS 6 and 7)**
```
chattr -R -i /usr/local/cwpsrv/var/services/
cd /usr/local/cwpsrv/var/services/
wget static.cdn-cwp.com/files/cwp/el7/cwp-services.zip
unzip -o -q cwp-services.zip
rm -f cwp-services.zip

if you delete /root/.my.cnf, you may be screwed.

you can try /scripts/mysql_pwd_reset
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Trying to start mysql server, please wait! help!!!!!
« Reply #2 on: June 05, 2020, 04:46:04 AM »
I was deleting in the file manager, backup folders of my sites, and in the home directory also directories of sites that I no longer use or were created directly there.

Offline
*
Re: Trying to start mysql server, please wait! help!!!!!
« Reply #3 on: June 05, 2020, 04:50:12 AM »
Please confirm MySQL root password reset. Continue? (y/N): y
Shutting down any mysql processes...
Stopping mysqld (via systemctl):                           [  OK  ]
mysqld: no process found
Resetting password... hold on
ERROR 1146 (42S02) at line 1: Table 'mysql.user' doesn't exist
Cleaning up...
Stopping mysqld (via systemctl):                           [  OK  ]
Killed mysqld(6835) with signal 15
Starting mysqld (via systemctl):  Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
                                                           [FAILED]
 ERROR! MySQL is not running

Password reset has been completed

New MySQL root password: xxxxxxxxxxx

Remember to store this password safely!

Offline
****
Re: Trying to start mysql server, please wait! help!!!!!
« Reply #4 on: June 05, 2020, 05:24:36 AM »
Your going to want to reinstall mysql/mariadb.  After reinstalling, you will have to restore databases.
Google Hangouts:  rcschaff82@gmail.com

Offline
*
Re: Trying to start mysql server, please wait! help!!!!!
« Reply #5 on: June 05, 2020, 05:53:19 PM »

how do i re-install and then restore databases

thanks