Mac Access denied for user ' root ' @ ' localhost ' (using Password:yes)

1: The bottom point of apple---system preferences, MySQL turn off MySQL service in the pop-up page

2:start it in Safe mode

Enter terminal

Input:

cd/usr/local/mysql/bin/

Login Administrator rights after enter

sudo su

Enter the following command after carriage return to disable the MySQL authentication feature

./mysqld_safe--skip-grant-tables &

3) Open Another terminal and run the following command (Keep last terminal Open)

mysql -u root

4) Run The following command with suitable new password on the MySQL console

mysql > UPDATE mysql.user SET Password=PASSWORD(‘password‘) WHERE User=‘root‘;

5)mysql > FLUSH PRIVILEGES;

6) Quit from both terminals and open new terminal and connect to MySQL with root user and new password

mysql -uroot -p

Mac Access denied for user ' root ' @ ' localhost ' (using Password:yes)