Mysqli connection refused for root user in Cent OS

Suddenly I got this error while trying to login to the CWP Control panel.

Code: [Select]

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0

Warning: mysqli_connect(): (HY000/2002): Connection refused 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 tried resetting the root password too. Also I have checked and confirm that the root password is same in both /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

Someone please help.

Paste the last contents of this log file

Code: [Select]

/var/lib/mysql/your-HOSTNAME.err
To do this use SSH. open the file using

Code: [Select]

vi /var/lib/mysql/your-HOSTNAME.err
Also do the same for this log -

Code: [Select]

/var/log/cwp_client_login.log

such files not available in the mentioned directories.

replace your-HOSTNAME with your actual hostname

I got you, but the files doesn't exist. I only have the last file i.e. cwp_client_login.log

Code: [Select]

2021-06-16 21:08:38 root Successful Login from: 59.94.72.224 on: https://localhost:2031/login/index.php
2021-06-16 21:15:17 root Successful Login from: 59.94.72.224 on: https://localhost:2031/login/index.php
2021-06-16 21:19:07 root Successful Login from: 59.94.72.224 on: https://localhost:2087/login/index.php

Try update CWP from ssh

Code: [Select]

sh /usr/local/cwpsrv/htdocs/resources/scripts/update_cwp

Getting the same error while updating cwp too:

Code: [Select]

[root@vmi426849 ~]# sh /usr/local/cwpsrv/htdocs/resources/scripts/update_cwp


====================================================
============= CentOS Web Panel Cron ================
====================================================


###########################
Firewall Flush Daily Blocks
###########################


######################
Update Server Packages
######################
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0
PHP Warning:  mysqli_connect(): (HY000/2002): Connection refused in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php on line 0
PHP Warning:  mysqli_select_db() expects parameter 1 to be mysqli, boolean given in /usr/local/cwpsrv/htdocs/resources/admin/include/cron.php on line 0
[root@vmi426849 ~]#


Reset MySQL password by first stopping all processes using mysql

Code: [Select]

killall mysqld then start mysql removing all permissions

Code: [Select]

mysqld_safe --skip-grant-tables
Now reset the password with sql query

Code: [Select]

update user set Password=PASSWORD('your-new-password') where user='root';
Flush privileges and restart mysql service

Code: [Select]

service restart mysql

Syntax error after 3rd step:

Code: [Select]

[root@vmi426849 ~]# killall mysqld
[root@vmi426849 ~]# mysqld_safe --skip-grant-tables
210617 14:25:06 mysqld_safe Logging to '/var/lib/mysql/vmi426849.cubinix.com.err'.
210617 14:25:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[root@vmi426849 ~]# update user set Password=PASSWORD('5d89TF5Ug3N06qg') where user='root';
-bash: syntax error near unexpected token `('
[root@vmi426849 ~]#

The last command is a mysql command open mysql from ssh using command

Code: [Select]

mysql --user=root mysql

Hi,

I tried something else and it fixed almost 90% of the issue.

1. I have taken backup of the database folders from /var/lib/mysql/
2. Removed MariaDB and the directories.
3. Reinstalled the MariaDB.
4. Copied the backed up database folders to /var/lib/mysql/
5. Granted permissions to the folder.
6. Reset myswl password.

Now I can login to my CWP. But still I'm getting the following error message in the header area:

Code: [Select]

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'postfix'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/resources/admin/include/functions.php on line 0

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'postfix'@'localhost' (using password: YES) in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Also, the FTP Server showing failed in the CWP Dashboard. If I try to start, it shows:

Code: [Select]

Failed to start pure-ftpd.service: Unit pure-ftpd.service not found.

I have fixed the postfix issue. And for FTP issue, I have reinstalled pure-ftpd. The FTP service is now started. But in the FTP status I noticed this line:

Code: [Select]

Jun 17 22:48:10 vmi426849.cubinix.com systemd[1]: pure-ftpd.service: Can't open PID file /var/run/pure-ftpd.pid (yet?) after start: No such file or directoryPlease help!

Code: [Select]

chown root:pure-ftpd /var/run/pure-ftpd.pid
chmod 755 /var/run/pure-ftpd