We wanted to let you know that we have become aware of an issue updating from MariaDB 10.3.22 to 10.3.23. This is being shown to break the cPanel -> MySQL Databases interface. This MariaDB update occurs automatically when updating cPanel with a version that includes support for MariaDB 10.3.
MariaDB 10.3.23 on cPanel breaks after update
The cPanel -> MySQL Databases interface will display these errors:
“The MySQL server is currently offline.”
“Error encountered while fetching data: There is no such grant defined for user ‘cpses_username’ on host ‘localhost’ DBDISKUSED cpuser_user 0 DISKUSED 0 DB cpuser_user USER cpuser_db”
How to fix Problem:
You need to change the MariaDB database to a lower version using the following command.
yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
Attention: This solution worked when MariaDB 10.3.23 on cPanel breaks and you see the error on the customer database page like above. So be careful when you want to downgrade your MariaDB.
If you have any questions, you can question them in the Ask Eldernode.