CWP Painel Root - MySQL Error Connection

[crashzk]

Today I started getting the following error on my CWP:

Code Select Expand


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 Expand

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 Expand


**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.

[Namaste]

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.

[cyberspace]

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 Expand

/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 Expand

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.

[studio4host]

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 Expand

/scripts/mysql_pwd_reset

[Namaste]

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 Expand

/scripts/mysql_pwd_reset

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

[Namaste]

Oddly, the User Tab on mysql manager DOES NOT EVEN OFFER A CREATE USER.   That sounds like total insanity to me. 

[Namaste]

Cant we go back to the original mysql manager where everything worked PERFECTLY?

[Namaste]

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 Expand

/scripts/mysql_pwd_reset

Resetting password is not going to fix the inability for user creation.

[Com-QuadTech]

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

[Sandeep]

will be fixed in new version

[Namaste]

Thanks!

[Com-QuadTech]

will be fixed in new version

And when ?

[Namaste]

will be fixed in new version

And when ?

Patience grasshopper.

[Namaste]

will be fixed in new version

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

[Namaste]

will be fixed in new version

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

Nor did 1101.