MySQL and the lost root password – part two
OK – so far so good. Flushing passwords worked OK. The next bit – setting a root password again might cause the same error. But it’s working locally, away from the internet, so for today it stays.
Note: restarting the mysqld_safe process requires killing the mysqld process that is running.