Expired MySQL 5.7 Password reset

[Raymond Geerts]

After doing a fresh install of MySQL 5.7 on macOS High Sierra, the installer generates a temporary password for the root user. The problem is as soon the installer is finished, the given root password is already expired. Resulting in not being able to login as root to MySQL.

It took me a while of reading, fiddling around, and trying all kinds of tips and examples on how to reset the root password.

The following worked for me. And in the hope it an help somebody else, and for backup purposes, I'll leave it here.

Open the following folder in a Terminal window:

/usr/local/mysql/bin

Type in (copy + paste) the following commands, where `xxxxxxxx` is the desired root password:

./mysql -u root -p --connect-expired-password

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('xxxxxxxx');

UPDATE user SET authentication_string='xxxxxxxx' WHERE User='root'

The last line with the UPDATE command was necessary for me to finish the process.