Re: Finding root password on new 5.7 install

[Charles Wangersky]

Yeah... not working.

The suggestion is to start MySQL with skip-grat-tables, invoke flush privileges to clear the ACL, then use either

alter user 'root'@'localhost' identified by 'somepassword';

or

set password for root@localhost = 'somepassword';

Both of these return

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

I had thought this was because I was including --skip-networking on the mysqld_safe invocation, but I restarted, reinvoked mysqld_safe without the --skip-networking option, and it still failed exactly the same way.

One perhaps important piece of missing information:
Server version: 5.7.30-0ubuntu0.18.04.1 (Ubuntu)