Symptoms
The following error is shown to run any mysql command after upgrade to MariaDB 10.3:
ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
Cause
It is caused by a MariaDB upgrade bug MDEV-14367
The unix_socket authentication plugin is not enabled by default on the MariaDB upgrade.
Plesk bug with ID PPPM-11057 has been created in order to track the issue.
Note: Consider subscribing to this article in order to get notified when the fix is released or check for the ID in our changelog
Resolution
As a workaround enable auth_socket.so plugin:
Debian-based distributions
- Open the
/etc/mysql/mariadb.conf.d/50-server.cnffile in a text editor. In this example, we are using the vi editor:# vi /etc/mysql/mariadb.conf.d/50-server.cnf
- Add the line below
[mysqld]section:plugin-load-add = auth_socket.so
-
Save the changes and close the file.
-
Restart MariaDB service
# service mariadb restart
Red Hat-based distributions
- Open the
/etc/my.cnffile in a text editor. In this example, we are using the vi editor:# vi /etc/my.cnf
- Add the line below
[mysqld]section:plugin-load-add = auth_socket.so
-
Save the changes and close the file.
-
Restart MariaDB service:
# service mariadb restart