MariaDB ERROR 1524 Plugin unix_socket is not loaded

After upgrading MariaDB on Ubuntu server, i got following error

root@server:~# mysql
ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
root@server:~#

Users created worked fine. Only root user had this error.

To fix, you need to enable auth_socket.so plugin.

Advertisement

Edit file

vi /etc/mysql/mariadb.conf.d/50-server.cnf

Find

[mysqld]

Add below

plugin-load-add = auth_socket.so

Resatrt MariaDB

systemctl restart mysqld
Add a comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Advertisement