Problems and solutions for MYSQL5.7.17 connection failure under MAC

The problem that MYSQL5.7.17 cannot connect under MAC. After downloading and installing SQLBench_community 6.3.9, the new MYSQL CONNECTIONS cannot connect at all, and it prompts that the password is wrong.

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

Step 1:

Apple->System Preferences->Click MySQL at the bottom. In the pop-up page, turn off the MySQL service (click stop MySQL server);

Step2:

Enter the terminal and enter: cd /usr/local/mysql/bin/

After pressing Enter, log in with administrator privileges sudo su

After pressing Enter, enter the following command to disable the mysql authentication function./mysqld_safe --skip-grant-tables &

After pressing Enter, MySQL will automatically restart (the status of MySQL in the preferences will become running)

Step 3:

Enter the command ./mysql

After pressing Enter, enter the command FLUSH PRIVILEGES;

After pressing Enter, enter the command SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your new password');

At this point, the password change is complete and you can log in successfully.

The above is the problem and solution of MYSQL5.7.17 not being able to connect under MAC introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!