MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”

by

I got a solution!

When resetting the root password at step 2), also change the auth plugin to mysql_native_password:

use mysql;
update user set authentication_string=PASSWORD("") where User="root";
update user set plugin="mysql_native_password" where User="root";  # THIS LINE

flush privileges;
quit;

This allowed me to log in successfully!

Full code solution

1. First, run these bash commands

sudo /etc/init.d/mysql stop # stop mysql service
sudo mysqld_safe --skip-grant-tables & # start mysql without password
# enter -> go
mysql -uroot # connect to mysql

2. Then run mysql commands => copy paste this to CLI manually

use mysql; # use mysql table
update user set authentication_string=PASSWORD("") where User="root"; # update password to nothing
update user set plugin="mysql_native_password" where User="root"; # set password resolving to default mechanism for root user

flush privileges;
quit;

3. Run more bash commands

sudo /etc/init.d/mysql stop 
sudo /etc/init.d/mysql start # reset mysql
# try login to database, just press enter at password prompt because your password is now blank
mysql -u root -p

4. Socket issue (from your comments)

When you see a socket error, a community came with 2 possible solutions:

sudo mkdir -p /var/run/mysqld; sudo chown mysql /var/run/mysqld
sudo mysqld_safe --skip-grant-tables &

(thanks to @Cerin)

Or

mkdir -p /var/run/mysqld && chown mysql:mysql /var/run/mysqld

(thanks to @Peter Dvukhrechensky)

Blind paths and possible edge errors

Use 127.0.0.1 instead of localhost

mysql -uroot # "-hlocalhost" is default

Can lead to “missing file” or slt error.

mysql -uroot -h127.0.0.1

Works better.

Skip the socket issue

I’ve found many ways to create mysqld.sock file, change access rights, or symlink it. It was not the issue after all.

Skip the my.cnf file

The issue also was not there. If you are not sure, this might help you.

More Related Contents:

  1. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. Can’t connect to MySQL server error 111 [closed]
  4. How do I find the MySQL my.cnf location
  5. MySQL: How to reset or change the MySQL root password?
  6. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  7. MySQL – ERROR 1045 – Access denied
  8. Remote Connections Mysql Ubuntu
  9. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  10. Install MySQL on Ubuntu without a password prompt
  11. How to insert BLOB and CLOB files in MySQL?
  12. Removing MySQL 5.7 Completely [closed]
  13. Bash script to insert values in MySQL
  14. How to change MySQL table names in Linux server to be case insensitive?
  15. Commit data in a mysql container
  16. libmysqlclient15-dev on macs?
  17. How to change the mysql root password
  18. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysql.sock’ (2)
  19. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  20. MYSql config bind-address set to 0.0.0.0 but netstat shows different on Ubuntu
  21. Linux shell script for database backup
  22. Codeigniter – multiple database connections
  23. How to add levenshtein function in mysql?
  24. Is the primary key automatically indexed in MySQL?
  25. Is there ANY_VALUE capability for mysql 5.6?
  26. How to connect to a MySQL Data Source in Visual Studio
  27. DOs and DONTs for Indexes [closed]
  28. Count with IF condition in MySQL query
  29. Using DISTINCT and COUNT together in a MySQL Query
  30. What happens when I exhaust a bigint generated key? How to handle it?

Leave a Comment