The connection failure of MYSQL5.7.17 in MAC and its solution are as follows: macmysql5.7.17

The connection failure of MYSQL5.7.17 in MAC and its solution are as follows: macmysql5.7.17

MYSQL5.7.17 cannot be connected on MAC. After SQLBench_community 6.3.9 is downloaded and installed, new mysql connections cannot be connected at all. The error message is "Incorrect password.

Details: Access denied for user 'root' @ 'localhost' (using password: YES)

Step 1:

Apple-> system preference settings-> at the bottom of the page, click MySQL to close the mysql Service (Click stop mysql server );

Step 2:

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

Press enter and log on to the Administrator sudo su.

Press enter and enter the following command to disable mysql verification./mysqld_safe -- skip-grant-tables &

After you press enter, mysql will automatically restart (mysql in preference settings will change to running)

Step 3:

Enter the command./mysql

Enter the command flush privileges;

Press enter and enter the command set password for 'root' @ 'localhost' = PASSWORD ('your new password ');

At this point, the password has been changed and can be successfully logged on.

The above section describes the connection failure problem and solution of MYSQL5.7.17 on MAC. I hope it will help you. If you have any questions, please leave a message, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!