After MariaDB update one user broke

[ericosman]

Hi,

I have the isse that after updating MariaDB 11.4 to 11.8 that one user broke, all wordpress sites under that give error "Error connecting to database".
All other users *also* running Wordpress sites have no issues at all.

Other types of websites under this same user have no issue (only the wordpress sites) before the update they were working tho.

Does anyone have an idea?

 

[ericosman]

Also i get this in Wordpress manager

 

[Richard G]

Have you checked the MariaDB/Mysql log what that says?

Was it fully up to date before the update, even plugins?
Might be a caching issue.

Did you check if you can manually connect to the database of that wordpress file with a test file?
Found a nice example on the net.

Create a php file like test.php or something in the public_html of dat domain with this content:

<?php
$link = mysqli_connect('localhost', 'dbusername', 'dbpassword');
if (!$link) {
die('Could not connect: ; '. mysqli_error());
}
echo 'Connected successfully';
mysqli_close($link);
?>

Ofcourse replace the username and password with the WP database credentials of the user. If it says Connected Successfully than at least that part is still fine. And then it should be something within WP most likely.

 

[ericosman]

Strange, i fixed it by creating a new database user, and connecting it to the database…

 

[Richard G]

That was the idea I had in mind, which was why I suggested that test. Trying to create a new user/pass for the database would have been the follow up on that.
Glad to see you fixed it!