MySQL Forums
Forum List  »  Install & Repo

Re: Finding root password on new 5.7 install
Posted by: Charles Wangersky
Date: May 05, 2020 09:57AM

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)

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.