Error establishing a database connection

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 ‘w8WI11****’@’localhost’ (using password: NO) in /home/mydomain.com/public_html/wp-includes/wp-db.php on line 1653

• This reply was modified 3 years, 11 months ago by bcworkz.

Not sure why this is happening. Everything seems OK to me. One more thing you can try creating a new user and a new password.

I’m getting the DB error message when I just checked now. If it was working for Bunty 11 hours ago, it’s an intermittent problem that’s probably beyond your ability to correct, you’ll need to bring in your host’s tech support for help.

If the user name you posted was your actual DB user name (I obfuscated it just in case), I recommend creating a new user like Bunty suggests, then removing the user whose name was published here. While technically speaking, exposing the user name is not a security risk, assuming you use good strong passwords, it’s better the entire world doesn’t know of it all the same. Even though it’s no longer available here, it had been exposed to the world for over half a day.

If assigning a new user does not help with connecting, you’ll need your host to help you resolve the issue, even if it’s a persistent problem and not intermittent.

It is not an intermittent issue, it’s not been working for over 15 hours and it didn’t work for Bunty either.

New user and/or new password doesn’t work, I tried it. Plus under CyberPanel all that infrastructure happens behind the scene anyway, so that suggestion is not viable, it means everything needs to be recreated from scratch.

The host is not in willing nor able to help with this as this is an application issue for them. Neither is CyberPanel, unfortunately.

You can try Reset permission OR Grant Permissions to the user in MySQL.

Maybe this helps
https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql

Hi Bunty,

I know I could.

But the reason I’m cautious about messing with users any further (without some guidance from CyberPanel community, hopefully) is because CyberPanel creates several DBs, the user, and the password when one creates an ‘application’ (in CP’s terminology) in it, and by browsing through their code I can see that it’s a Django app with a bunch of internal DBs, for example it has a separate DB (named mysql) in which all the users are stored, separately from the WordPress-related DB (called by CyberPanel process identically as the corresponding user). It can be viewed at https://mydomain.com:8090/phpmyadmin/sql.php?server=1&db=mysql&table=user&pos=0 There’s an encrypted password in that table too. I’m just unsure where else the rest of the different pieces may be located.

I also attempted to access the WordPress DBs directly from php script, with the similar result which means that WP access is being blocked (by CyberPanel) whereas phpAdmin seems to be able to manipulate the internal DBs (though w/o luck) which confirms my hunch that there is some missing link somewhere else preventing normal functioning of the site.

I posted more details here https://stackoverflow.com/questions/65317075/error-establishing-database-connection-on-wordpress-site-in-cyberpanel (as SO is much better at allowing users to edit questions and use images/attachments) as well as at CyberPanel forum (which is normally unresponsive)

Thanks.

There are 4 major reasons for showing error establishing a database connection. See how to fix error establishing a database connection in WordPress. I hope it will work.