The most MySQL can be set when installed, but the lower version of the seemingly no, need to be installed in order to set up.
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.
Enter the command (set password for ' root ' @ ' localhost ' = password (' root '), the root in password (' root ') is the new password, set it freely, semicolon do not forget to enter
At this point, the password changes successfully, you can log in normally.
Mac version 5.6 MySQL set password