Problems and solutions of MYSQL5.7. 17 connection under MAC

MYSQL5.7. 17 can't be connected under MAC. After downloading and installing SQLBench_community 6.3. 9, the newly built MYSQL CONNECTIONS can't be connected at all, prompting that the password is wrong.

The specific performance is: Access denied for user 'root' @ 'localhost' (using password: YES)

Step1:

Apples-- > System Preferences- > The bottom point MySQL closes the mysql service in the pop-up page (click stop mysql server);

Step2:

Enter terminal input: cd/usr/local/mysql/bin/

Login Administrator Permission sudo su after Enter

Enter to disable the mysql authentication function./mysqld_safe-skip-grant-tables &

mysql will restart automatically after carriage return (the status of mysql in preferences will change to running)

Step3:

Enter commands./mysql

Enter the command FLUSH PRIVILEGES;

Enter and enter the command SET PASSWORD FOR 'root' @ 'localhost' = PASSWORD ('Your New Password');

At this point, the password modification is completed and you can log in successfully.