After completing an upgrade of MariaDB from 10.3 to 10.5 after the latest Cpanel upgrade, all database users passwords were wiped. These are specifically WordPress websites, and all sites went down with "error establishing database connection".
Luckily we did it on a smaller server, but there were close to 35 databases that I was required to go to each WordPress site, check wp-config and update the passwords...one by one.
Before we proceed to larger servers, we need to be able to understand why this happened....doing 300 to 500 databases would be an utter failure.
In looking at the upgrade log, there is nothing that seems out of the ordinary. And usually when we setup new VPSs, we upgrade from Mysql to maria10.3 with zero issues. Seems to be a maria to maria upgrade in place that is a problem.
I am willing to hear ideas of how we can preserve the passwords. As right now, we have quite a few servers that need updates...but, not with this kind of disaster.
Thanks for any help...
Luckily we did it on a smaller server, but there were close to 35 databases that I was required to go to each WordPress site, check wp-config and update the passwords...one by one.
Before we proceed to larger servers, we need to be able to understand why this happened....doing 300 to 500 databases would be an utter failure.
In looking at the upgrade log, there is nothing that seems out of the ordinary. And usually when we setup new VPSs, we upgrade from Mysql to maria10.3 with zero issues. Seems to be a maria to maria upgrade in place that is a problem.
I am willing to hear ideas of how we can preserve the passwords. As right now, we have quite a few servers that need updates...but, not with this kind of disaster.
Thanks for any help...