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

FarzadKhazaei

Registered
May 13, 2020
2
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

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
Good Morning - v86.0.20 Just officially went to stable/release but you were able to get it late last night. Please let us know if you continue to experience issues.
 
  • Like
Reactions: AzeDK and bejbi

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
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

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston

anoopk350

Well-Known Member
May 6, 2020
73
9
8
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
 

pheberta

Registered
Jun 21, 2020
1
0
1
Canada
cPanel Access Level
Root Administrator
Doesn't work for me:
The MySQL server is currently offline.
Code:
DBDISKUSED phebert_wp 24412160 DBDISKUSED phebert_rot 9420800 DBDISKUSED phebert_ca_wp 19891662 DBDISKUSED phebert_rd 0 DISKUSED 53724622 DB phebert_ca_wp DBUSER phebert_ca_wp phebert_ca_wp DB phebert_rot DBUSER phebert_rot phebert_rot DB phebert_wp DBUSER phebert_wp phebert_wp DB phebert_rd USER phebert_rde
v88.0.10
MySQL 8.0.20

Was working fine, created new DB, new USER assigned USER to DB with all privileges. Go to install phpbb and it say's can't connect, now cPanel Database page is broken!?

I am admin of the WHM/cPanel server. I don't know how to fix this, please help.
 
Last edited:

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,252
313
Houston
This issue is completely unrelated to the issue noted in this thread @pheberta if you're still experiencing issues with this
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!
 

lukapaunovic

Well-Known Member
Jul 29, 2012
51
0
56
Užice, Serbia
cPanel Access Level
Root Administrator
There's a problem again with 10.3.26-MariaDB I downgraded to 10.3.25-MariaDB
And it's working again.

When it's on .26 it's showing:

The MySQL server is currently offline.
adminbin Cpanel/cpmysql/DBCACHE: exit 11

This is the error:

warn [cpmysql] Error (Invalid grant string: SET DEFAULT ROLE 0 FOR 'mycpaneluser'@'localhost'
) while parsing grant: SET DEFAULT ROLE 0 FOR 'mycpaneluser'@'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 956, <STDIN> line 1.
 

sjcwatterson

Registered
Dec 18, 2019
1
0
1
Vancouver BC
cPanel Access Level
Root Administrator
Thanks for posting this!!!

I was going nuts trying to figure this out. The yum downgrade worked:

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

directsupport

Member
Dec 14, 2010
12
0
51
Thanks for posting this!!!

I was going nuts trying to figure this out. The yum downgrade worked:

Bash:
yum downgrade MariaDB-server MariaDB-common MariaDB-shared MariaDB-client MariaDB-compat MariaDB-devel
Same - all servers were the same after the last update.

Broken the cPanel Database interface yet again.

Thanks for the temporary fix.