====== Plugin 'unix_socket' is not loaded  ======

The "unix_socket" has been called by mysql authentication process (maybe related to a partial migration of database to mariadb, now removed). To get all stuff back working go su:


then follow:

<code>/etc/init.d/mysql stop
mysqld_safe --skip-grant-tables &
mysql -uroot</code>
This will completely stop mysql, bypass user authentication (no password needed) and connect to mysql with user "root".

Now, in mysql console, go using mysql administrative db:

<code>use mysql;</code>
To reset root password to mynewpassword (change it at your wish), just to be sure of it:

<code>update user set password=PASSWORD("mynewpassword") where User='root';</code>
And this one will overwrite authentication method, remove the unix_socket request (and everything else), restoring a normal and working password method:

<code>update user set plugin="mysql_native_password";</code>
Exit mysql console:

<code>quit;</code>
Stop and start everything related to mysql:

<code>/etc/init.d/mysql stop
kill -9 $(pgrep mysql)
/etc/init.d/mysql start</code>




That's it.