How to "defeat" the error: ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded?

Question

MySQL

Installed MySQL on Ubuntu 16.04 LTS when trying to login:
>mysql -u root -p
Error ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

Answer 1

Found the answer on the Internet: https://www.versatilewebsolutions.com/blog/2015/05...
In short:
1. Find the my.cnf configuration file in the /etc/mysql/ directory, and edit it - add it at the very bottom of the file
[mysqld] plugin-load-add
= auth_socket.so
and save the file gksu , if the gksu package is not installed, more details here: https://losst.ru/kak-redaktirovat-fajly-v-ubuntu 2. Restart mysql with the command sudo systemctl restart mysql.service 3.
After these steps, everything worked for me !!!

Answer 2

The above solution did not help, the error is the same as that of Vladimir .
System: Debian 9 Stretch [amd64]

Answer 3

This error occurs when the table with users is damaged.
To fix it, you can start mysql server in unrestricted mode (& means in the background)
sudo mysqld_safe --skip-grant-tables &
Or by normal start with a parameter in my.ini

[mysqld]
skip-grant-tables

You can connect without a password
mysql -uroot
Update the password for root

use mysql
update user set password=PASSWORD("new_password") where user='root';

After that, you can start the server in normal mode.