Plesk MariaDB 10.3 error after upgrade | An easy fix

Plesk MariaDB 10.3 error after upgrade causing trouble? Our in-house experts have a solution.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped out a customer with the Plesk MariaDB 10.3 error after upgrade.

How to resolve Plesk MariaDB 10.3 error after upgrade

If you have been coming across the following error, you have come to the right place!

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

According to our Support Techs, the error is due to a MariaDB upgrade bug MDEV-14367. Consequently, the error causes the unix_socket authentication plugin to remain disabled by default on the MariaDB upgrade. We can use the Plesk bug with ID PPPM-11057 to track the issue.

However, if you do not want to wait around for a fix, our Support Team has come up with a workaround that works perfectly. It involves enabling the auth_socket.so plugin.

Workaround solution for Debian-based distributions

1. First, we have to open the /etc/mysql/mariadb.conf.d/50-server.cnf file via any text editor.

   For instance, if we open it with vi editor:

   # vi /etc/mysql/mariadb.conf.d/50-server.cnf
2. Then, we will add the following line to the [mysqld] section:

   plugin-load-add = auth_socket.so
3. After that, we will save the changes and close the file.
4. Finally, we have to restart the MariaDB service with the following command:

   # service mariadb restart

Workaround solution for RedHat-based distributions

1. First, we have to open the /etc/my.cnf file via any text editor.

   For instance, if we open it with vi editor:

   # vi /etc/my.cnf
2. Then, we will add the following line to the [mysqld] section:

   plugin-load-add = auth_socket.so
3. After that, we will save the changes and close the file.
4. Finally, we have to restart the MariaDB service with the following command:

   # service mariadb restart

[Seeking a solution to another query? We have your back.]

Conclusion

In brief, the skilled Support Engineers at Bobcares demonstrated how to resolve Plesk MariaDB 10.3 error after the upgrade.