Ubuntu
mysql-5.7 package

  1. Bug #1571668
  2. Comment #2

Comment 2 for bug 1571668

Revision history for this message
Dario Bertini (berdario) wrote :

I just realized that not even the

mysqld_safe --skip-grant-tables --skip-networking

solution will work, since after logging in

ALTER USER 'root'@'localhost' IDENTIFIED BY '';

will fail with

ERROR 1524 (HY000): Plugin 'auth_socket' is not loaded

(the same applies for the old command: `SET PASSWORD FOR 'root'@'localhost' = PASSWORD('');`)

And trying

install plugin auth_socket soname 'auth_socket.so';

will only result in

ERROR 1030 (HY000): Got error 1 from storage engine