Advance

MariaDB 10.3.23 on cPanel breaks the MySQL Databases interface

MariaDB 10.3.23 on cPanel breaks the MySQL Databases interface

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

Error Symptoms:

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”

Recommended Article: Tutorial add a new disk to Linux server

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.

View More Posts
Tom Veitch
Eldernode Writer
We Are Waiting for your valuable comments and you can be sure that it will be answered in the shortest possible time.

Leave a Reply

Your email address will not be published. Required fields are marked *

We are by your side every step of the way

Think about developing your online business; We will protect it compassionately

We are by your side every step of the way

+8595670151

7 days a week, 24 hours a day