mysql5.7.18 connection error under Mac, error message: Access denied for user ' root ' @ ' localhost ' (using Password:yes)
() inside the command entered for the shell, be sure to lose all including;& and other symbols
First step: Apple---system Preferences--bottom point MySQL, turn off MySQL service
Step Two: Enter terminal input (cd/usr/local/mysql/bin/) Carriage return
Enter (sudo su) carriage return for administrator privileges
Input (./mysqld_safe--skip-grant-tables &) Enter to disable MySQL authentication, MySQL will restart automatically and MySQL status in preferences will change to running
Step three: Enter the command (./mysql) Carriage return
Input command (flush privileges; ) Semicolon don't forget to lose.
Input command (set password for ' root ' @ ' localhost ' = password (' root '); ) root in Password (' root ') is the new password, set it yourself, semicolon don't forget to enter
Restart Navicat Reset the password for the Connection property to the password you just set
At this point, the password changes successfully, you can log in normally.
mysql5.7.18 connection error under Mac, error message: Access denied for user ' root ' @ ' localhost ' (using Password:yes)