Author Topic: CWP Painel Root - MySQL Error Connection  (Read 1177 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
CWP Painel Root - MySQL Error Connection
« on: October 20, 2021, 02:47:38 AM »
Today I started getting the following error on my CWP:
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 Control 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've already tried running the command he quotes.

Code: [Select]
Trying to start mysql server, please wait!
Try to restart Control Web Panel with command: sh /scripts/restart_cwpsrv

But nothing, same error yet.

I also checked the MySQL Root Password:
Code: [Select]
**Check your MySQL root password in: /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php and /root/.my.cnf

How can I fix it? All my clients are offline as they don't have access to the MysQL database.

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #1 on: October 30, 2021, 12:46:43 AM »
Yeah, I have exactly the same thing.  And you will not be able to create db user.

When you get that error page, hit reload several times and the cwp will come back with db server running.

But still no way to create new users.
Listen to everything Pixelpadre says.

Offline
*
Re: CWP Painel Root - MySQL Error Connection
« Reply #2 on: November 02, 2021, 12:11:27 PM »
Hi,

1. What does happen when you just run "mysql" in shell ? Are you able to connect to MySQL/MariaDB at all ?

2. Please make sure the login details listed in the file:

Code: [Select]
/usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
are correct and CWP is able to connect to the database with the login credentials from file. Just run the command provided below in shell:

Code: [Select]
mysql -u db_user -p db_pass -h localhost db_name
Replace db_user, db_pass, db_name with the actual values from the file.

Offline
*
Re: CWP Painel Root - MySQL Error Connection
« Reply #3 on: November 03, 2021, 09:09:00 AM »
first, check if MySQL is running and if it's working ok then only the password is an issue which you can fix by running this command

Code: [Select]
/scripts/mysql_pwd_reset
VPS & Dedicated server provider with included FREE Managed support for CWP.
http://www.studio4host.com/

*** Don't allow that your server or website is down, choose hosting provider with included expert managed support for your CWP.

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #4 on: November 05, 2021, 07:53:48 PM »
first, check if MySQL is running and if it's working ok then only the password is an issue which you can fix by running this command

Code: [Select]
/scripts/mysql_pwd_reset

You are missing the entire point.  This is a system wide failure.  Has nothing to do with me or you.
Listen to everything Pixelpadre says.

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #5 on: November 05, 2021, 08:09:05 PM »
Oddly, the User Tab on mysql manager DOES NOT EVEN OFFER A CREATE USER.   That sounds like total insanity to me. 
Listen to everything Pixelpadre says.

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #6 on: November 05, 2021, 08:11:26 PM »
Cant we go back to the original mysql manager where everything worked PERFECTLY?
Listen to everything Pixelpadre says.

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #7 on: November 05, 2021, 09:48:59 PM »
first, check if MySQL is running and if it's working ok then only the password is an issue which you can fix by running this command

Code: [Select]
/scripts/mysql_pwd_reset

Resetting password is not going to fix the inability for user creation.
Listen to everything Pixelpadre says.

Offline
*
Re: CWP Painel Root - MySQL Error Connection
« Reply #8 on: November 10, 2021, 12:20:12 AM »
Same problem and not working!

CentOS 7 MySQL: Creation of users not possible. The manual creation of a user via MyAdmin is not possible.

Mysql Manager creates DB but no user, the subsequent creation of a user with password and full rights fails.
Grant ** all ** privileges on database; # 1133 - Can't find any matching row in the user table

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

When creating the user with full rights via MyAdmin comes: Grant ** all ** privileges on database; # 1133 - Can't find any matching row in the user table

Offline
*****
Re: CWP Painel Root - MySQL Error Connection
« Reply #9 on: November 10, 2021, 05:38:42 PM »
will be fixed in new version

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #10 on: November 11, 2021, 12:07:37 PM »
Thanks!
Listen to everything Pixelpadre says.

Offline
*
Re: CWP Painel Root - MySQL Error Connection
« Reply #11 on: November 12, 2021, 03:42:23 PM »
will be fixed in new version

And when ?

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #12 on: November 12, 2021, 11:18:18 PM »
Listen to everything Pixelpadre says.

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #13 on: November 16, 2021, 11:18:51 PM »
will be fixed in new version

1100 did not fix the create new user in mysql manager.
Listen to everything Pixelpadre says.

Offline
**
Re: CWP Painel Root - MySQL Error Connection
« Reply #14 on: November 17, 2021, 01:28:12 PM »
will be fixed in new version

1100 did not fix the create new user in mysql manager.

Nor did 1101.
Listen to everything Pixelpadre says.