Text tutorial on resetting the password of mysql in Mac, macmysql

Text tutorial on resetting the password of mysql in Mac, macmysql

MySQL file in the path /usr/local/mysql Lower

1. Disable mysql: Stop MySQL Server in system preference settings

2. Open the terminal

Access path/usr/local/mysql/bin

Enter the sudo su command, and then enter the boot password.

Then enter the command:./mysqld_safe –skip-grant-tables

Command set

cd ／usr/local/mysql/bin         sudo su             ./mysqld_safe --skip-grant-tables 

3. Open a terminal again.

Enter the Directory /usr/local/mysql/bin

Enter the command mysql to enter mysql

Run the following command:

Use mysql; flush privileges; set password for 'root' @ 'localhost' = password ('new password ');

Then, the password is changed, and the command and terminal in step 2 are closed.

Command set

cd /usr/local/mysql/bin             mysql                  flush privileges;                set password for 'root'@'localhost'=password('chenchaotong'); 

4. Add the mysql command in the shell terminal.

Open a terminal

Command:vim ~/.bash_profile

Add the last line PATH=$PATH:/usr/local/mysql/bin, Save and exit

Commandsource ~/.bash_profile

5. Start mysql in the system preference settings.

Terminal input: mysql -u root -p

Note:

If you find that mysql cannot be closed or started in the system preference settings, shut down and restart.

The above section describes how to reset the password of mysql in Mac. I hope it will be helpful to you. If you have any questions, please leave a message and I will reply to you in a timely manner. Thank you very much for your support for the help House website!