SOLVED [CPANEL-32712] Updating to MariaDB 10.3.23 on cPanel breaks the MySQL Databases interface

FarzadKhazaei

Registered
May 13, 2020
1
0
1
Mashhad
cPanel Access Level
Root Administrator
Hell guys

After update to v86.0.20 still iam issue with mysql database.

Code:
The MySQL server is currently offline.
Error while connecting to MySQL: (XID tyc4wb) The system failed to connect to the “MySQL” database “mysql” because of an error: 1044 (Access denied for user 'root'@'localhost' to database 'mysql') Error while connecting to MySQL: (XID tyc4wb) The system failed to connect to the “MySQL” database “mysql” because of an error: 1044 (Access denied for user 'root'@'localhost' to database 'mysql') at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1.
Please see attached error screenshot

Please provide some solution asap.
Update cpanel to version 88.02
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
11,214
1,006
313
Houston
Hell guys

After update to v86.0.20 still iam issue with mysql database.

Code:
The MySQL server is currently offline.
Error while connecting to MySQL: (XID tyc4wb) The system failed to connect to the “MySQL” database “mysql” because of an error: 1044 (Access denied for user 'root'@'localhost' to database 'mysql') Error while connecting to MySQL: (XID tyc4wb) The system failed to connect to the “MySQL” database “mysql” because of an error: 1044 (Access denied for user 'root'@'localhost' to database 'mysql') at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 391, <STDIN> line 1.
Please see attached error screenshot

Please provide some solution asap.
Can you please open a ticket using the link in my signature? Once open please reply with the Ticket ID here so that we can update this thread with the resolution once the ticket is resolved.


Thanks!
 

cPanelLauren

Forums Analyst II
Staff member
Nov 14, 2017
11,214
1,006
313
Houston

anoopk350

Member
May 6, 2020
23
1
3
Kochi
cPanel Access Level
Root Administrator
Upgrade the mysql server to latest version. if its already in latest version, then try to downgrade it with following command.

yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel