Mac Install MySQL 5.7 After login cannot execute command "You must reset your password using ALTER USER statement before executing this statement."

Today installed on the Mac MySQL 5.7, after starting the service, enter Mysql-u root-p, enter the initial password, try to execute show databases;

reported a you must reset your password using the ALTER USER statement before executing this statement. Error.

Refer to Stack Overflow previous post https://stackoverflow.com/questions/33467337/ Reset-mysql-root-password-using-alter-user-statement-after-install-on-mac

The steps are as follows:

Set password = password (' Your new password ');

Alter user ' root ' @ ' localhost ' password expire never;

Flush privileges;

Mac Install MySQL 5.7 After login cannot execute command "You must reset your password using ALTER USER statement before executing this statement."