How to set password for mysql version 5.6 on mac

MySQL can be set when it is installed, but it seems that lower versions cannot be set and need to be set after installation.

Under mac, mysql5.7.18 connection error, error message: Access denied for user 'root'@'localhost' (using password: YES)

The commands in () are entered in the shell. You must enter them in full, including symbols such as ; &

Step 1: Apple->System Preferences->Click MySQL at the bottom to turn off the MySQL service

Step 2: Enter the terminal and type (cd /usr/local/mysql/bin/) and press Enter

Type (sudo su) and press Enter to obtain administrator privileges.

Enter (./mysqld_safe --skip-grant-tables &) and press Enter to disable the mysql authentication function. MySQL will automatically restart and the mysql status in the preferences will become running.

Step 3: Enter the command (./mysql) and press Enter

Enter the command (flush privileges;) Don’t forget to enter the semicolon

Enter the command (set password for 'root'@'localhost' = password('root');) The root in password('root') is the new password. You can set it at will. Don't forget to enter the semicolon.

At this point, the password has been changed successfully and you can log in normally.

Summarize

The above is the simple method I introduced to you for setting the password for MySQL version 5.6 on Mac. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time!