Hi,

Today, there has been an issue discovered on the latest update of the cPanel where a minor release of MariaDB was updated to the system causing issue with the database connection to many applications. Our team has found below error in the cPanel logs.

Code:
Nov 04 05:08:46 Updated: MariaDB-compat-10.3.26-1.el7.centos.x86_64
Nov 04 05:08:46 Updated: MariaDB-common-10.3.26-1.el7.centos.x86_64
Nov 04 05:09:27 Updated: MariaDB-client-10.3.26-1.el7.centos.x86_64
Nov 04 05:09:43 Updated: MariaDB-server-10.3.26-1.el7.centos.x86_64
Nov 04 05:09:50 Updated: MariaDB-devel-10.3.26-1.el7.centos.x86_64
Nov 04 05:10:19 Updated: MariaDB-shared-10.3.26-1.el7.centos.x86_64
Code:
[2020-11-04 10:50:57 +0100] warn [cpmysql] Error (Invalid grant string: SET DEFAULT ROLE 0 FOR 'USER'@'localhost'
) while parsing grant: SET DEFAULT ROLE 0 FOR 'USER'@'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 956, <STDIN> line 1.
        Cpanel::Mysql::__ANON__(__CPANEL_HIDDEN__...) called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 118
        Try::Tiny::try(CODE(0x30c0150), Try::Tiny::Catch=REF(0x314b328)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 957
        Cpanel::Mysql::_get_dbuser_privileges_on_db(Cpanel::Mysql=HASH(0x2ed5510), "USER") called at /usr/local/cpanel/Cpanel/Mysql.pm line 1379
        Cpanel::Mysql::_password_hashes(Cpanel::Mysql=HASH(0x2ed5510), ARRAY(0xd23618)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 528
        Cpanel::Mysql::updateprivs(Cpanel::Mysql=HASH(0x2ed5510)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 1209
        Cpanel::Mysql::dbcache(Cpanel::Mysql=HASH(0x2ed5510), "") called at bin/admin/Cpanel/cpmysql.pl line 388
Invalid grant string: SET DEFAULT ROLE 0 FOR 'USER'@'%'
The immediate fix for this issue would be downgrade the MariaDB built to last available minor release i.e., downgrade MariaDB version 10.3.26 to 10.3.25.


Code:
Nov 04 11:06:03 Installed: MariaDB-common-10.3.25-1.el7.centos.x86_64
Nov 04 11:06:04 Installed: MariaDB-compat-10.3.25-1.el7.centos.x86_64
Nov 04 11:06:33 Installed: MariaDB-client-10.3.25-1.el7.centos.x86_64
Nov 04 11:06:40 Installed: MariaDB-server-10.3.25-1.el7.centos.x86_64
Nov 04 11:06:41 Installed: MariaDB-devel-10.3.25-1.el7.centos.x86_64
Nov 04 11:07:09 Installed: MariaDB-shared-10.3.25-1.el7.centos.x86_64
Hope this helps other guys there who are facing the same issue.