MAC Mysql Reset Password

With a Mac computer, you need to reset your password when the MySQL login password is forgotten. The steps are as follows:

1. Close the currently running MySQL process.

A. Go to Preferences, select MySQL, and then choose "Stop MySQL server";

Or

B. You can use Activity Monitor (F4 go to select "Other", then "Activity Monitor") and then close the mysqld process

2. Open terminal, switch to root user: Su root

3. Go to MySQL installation directory: Cd/usr/local/mysql/bin

4. Run the command:./mysqld_safe--skip-grant-tables

5. Open a new terminal, switch to root user: Su root, enter directory: Cd/usr/local/mysql/bin

6. Open MySQL:./mysql

7. Get permission: Flush privileges;

7. Modify the root account password: Set password for ' root ' @ ' localhost ' =password (' new password ');

Modified successfully!

MAC Mysql Reset Password