The problem of MySQL can't login under Mac

Here are the easiest ways to restore root privileges and change the root password.

1: Install MySQL Workbench. The visual interface operates directly.

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

3: 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 &

After the carriage return, MySQL will automatically restart, restart the good after entering MySQL Workbench, this time can not need password login. Restart MySQL After you modify the root password directly

The problem of MySQL can't login under Mac