Symptoms
The system fails to set or change the password for a mysql user. An entry similar to the following can be seen in /usr/local/cpanel/logs/error_log.
The system received an error from the “MySQL” database “mysql”: ER_PARSE_ERROR (You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF EXISTS 'username'@'hostname' IDENTIFIED BY 'password; GRANT USAGE' at line 1)
Description
A bug in MariaDB versions before 10.3.23 prevented queries containing "IF EXISTS" from running.
Workaround
Upgrade to MariaDB version 10.3.23 or later.
How do I upgrade MySQL/MariaDB on my server?
"MariaDB*" must not be included in the 'exclude' line of yum.conf or dnf.conf. Including it in the 'exclude' line will prevent MariaDB from being upgraded.
exclude=MariaDB* courier* dovecot* exim* filesystem httpd* mod_ssl* mydns* nsd* p0f php* proftpd* pure-ftpd* spamassassin* squirrelmail*
Please note: databases should be backed up before upgrading MariaDB.
How to backup MySQL databases before doing a MySQL upgrade
Comments
0 comments
Article is closed for comments.