post

After upgrading MariaDB on Ubuntu server, i got following error
<pre>
root@server:~# mysql
ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded
root@server:~# 
</pre>
Users created worked fine. Only root user had this error.
To fix, you need to enable auth_socket.so plugin.
Edit file 
<pre>
vi /etc/mysql/mariadb.conf.d/50-server.cnf
</pre>
Find
<pre>
[mysqld]
</pre>
Add below
<pre>
plugin-load-add = auth_socket.so
</pre>
Resatrt MariaDB
<pre>
systemctl restart mysqld
</pre>
See <a href="https://serverok.in/mysql">MySQL</a>

MariaDB ERROR 1524 Plugin unix_socket is not loaded