I suddenly started getting an ‘Error establishing a database connection’ error on load of my WooCommerce site which is hosted on CyberPanel under Centos 8.
To understand what’s going on, I’ve put the following in wp_config.php:
( ! ) Warning: mysqli_real_connect(): (HY000/1045): Access denied for user ‘w8WI11jpe3wGCO’@‘localhost’ (using password: YES) in /home/mydomain.com/public_html/wp-includes/wp-db.php on line 1653
Call Stack
P.S. I also tried configuring this user to have no password and granting him all privileges, but that doesn’t change the situation either, except for the error message now reading as:
Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'w8WI11jpe3wGCO'@'localhost' (using password: NO) in /home/mydomain.com/public_html/wp-includes/wp-db.php on line 1653
I’d really appreciate it if someone knowledgeable from the cyberpanel team could suggest a fix for the described situation, I was thinking this was a go to place for anything CyberPanel and so far the response I’m getting hear is nothing spectacular. Thanks
Since this forum doesn’t have the ability to attach any pictures nor apply any reasonable editing to the messages, I’m adding a link where this issue is described more visually:
Ok, it was an error in PHPmyadmin, but it may provide clues. You may have to go direct into mysql and rejig the affected user details. Does not seem a terminal problem.
Did you make any changes to your server, CyberPanel or your WooC set-up prior to the database connection suddenly stopping?
FWIW I have installed CyberPanel, had a few issues, and now reckon the best option is to install OLS etc manually and learn proper SysAdmin via official documentation rather than rely on forums, free 1-click installs etc.