MYSQL5.7.17 under MAC cannot connect and prompts incorrect password. Solution steps

The problem of MYSQL5.7.17 under MAC cannot be connected. After downloading and installing SQLBench_community 6.3.9, the new MYSQL CONNECTIONS cannot be connected at all. The prompt is that the password is wrong. What is the reason and how to solve it? Today, the editor will answer the

problem that MYSQL5.7.17 under MAC cannot be connected. After downloading and installing SQLBench_community 6.3.9, the new MYSQL CONNECTIONS cannot be connected at all, and the prompt is that the password is wrong.

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

Step1:

Apple-> ;System Preferences->Click MySQL at the bottom and close the mysql service in the pop-up page (click stop mysql server);

Step2:

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

Press Enter to log in with administrator rights sudo su

Enter the following command after Enter to disable the mysql verification function./mysqld_safe --skip-grant- tables &

After pressing Enter, mysql will automatically restart (the status of mysql in the preferences will change to running)

Step3:

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 modification is completed and you can log in successfully.

The above is the detailed content of MYSQL5.7.17 under MAC cannot connect and prompts incorrect password. Solution steps. For more information, please follow other related articles on the PHP Chinese website!