Warning: mysqli_connect(): (HY000/1045) etc etc

Dear Sir,

I installed Centos web panel on a fresh installation of centos 7 web server locally. Everything works, including access to the CWP admin area which just logged in makes the following error. I looked for the solution on the web before writing, I followed every wise advice but nothing. I don't solve the problem.
Can this forum help me solve the problem?

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'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/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

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: YES) 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 (Failed to restart cwpsrv-phpfpm.service: Unit not found.)

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


Warning: mysqli_error() expects exactly 1 parameter, 0 given in /usr/local/cwpsrv/htdocs/admin/admin/index.php on line 0
Could not connect:

([root @ 192 ~] # wget https://192.168.1.11:2031/
--2020-03-16 09: 13: 04-- https://192.168.1.11:2031/
Connection to 192.168.1.11:2031...connected.
ERROR: impossible to verify the certificate of 192.168.1.11, issued by "/ C = HR / ST = Zagreb / ​​O = CentOS Web Panel / L = HR / CN = pettinati.ddns.net / OU = CentOS Web Panel / emailAddress = info @ studio4host.com "
  Found self-signed certificate.
    ERROR: the common certificate name "pettinati.ddns.net" does not match the host name  "192.168.1.11" required.
To connect to 192.168.1.11 in an unsafe way, use "--no-check-certificate".)

with best regards

Walter

hi check the mysql log is running or not and the logs for it why it have errors.

How can I solve it?

hi you can run this command only if you changed the root password for mysql

Code: [Select]

sh /scripts/mysql_pwd_reset

Hi

I am facing this issue when I try to login to phpmyadmin from the user cpanel, but phpmyadmin from the root dashboard works perfectly fine.

How can I fix this? My clients are unable to access their phpmyadmin page.

It took me a day to track it down but I finally found the solution.  You need to delete or rename the tc.log file in /var/lib/mysql

First shut down mysql then delete, then restart mysql.  Everything came back to me. 

I have to say that this all happened because I uploaded a filed that (long story short) got into a loop that ended up completely filling up my hard drive.  After that, I was dead in the water with any db sites.  Now all is well.

OK. all of my websites came back.  But the admin login page still gives me the white screen below.  Odd that all databases are working but cwp database.


Warning: mysqli_connect(): (HY000/1045): Access denied for user 'root'@'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 'root'@'localhost' (using password: YES) 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:

OK.  got cwp panel back.  Here was the problem. 

Apparently, the original root password in cwp database was not changed when I changed the password while the server was off.  So I searched the database and found the password field was encrypted.  So I tried the old original password in the mycnf file and the db_conn files. and restarted the mysql server.  Now I have the cwp panel working again. 

I will investigate separating the database from the apache server.