Solution to forgetting the MYSQL database password under MAC

Quick solution for forgetting MYSQL database password under Mac operating system

1. In System Preferences, stop the MYSQL service.

2. cd /usr/local/mysql-...../bin

sudo ./mysqld_safe --skip-grant-tables

3. Log in to MySQL;

mysql

4. Set the root user's password to blank;

mysql> update mysql.user set password='' whereUser='root'; 
mysql> flush privileges; 
mysql> quit

5. Restart the MySQL service.

6. Add password mysql> mysqladmin -u root -p password 123 Change the password to 123

Another method from netizens:

step1:

Shut down the MySQL service: Apple->System Preferences->Click MySQL at the bottom. In the pop-up page, shut down the MySQL service (click Stop MySQL Server).

step2:

Enter the terminal and type: cd /usr/local/mysql/bin/
After pressing Enter, log in with administrator privileges sudo su
After pressing Enter, enter the following command to disable the mysql authentication function./mysqld_safe --skip-grant-tables &
After pressing Enter, MySQL will automatically restart (the status of MySQL in the preferences will become running)

step3:

Enter the command ./mysql
After pressing Enter, enter the command FLUSH PRIVILEGES;
After pressing Enter, enter the command SET PASSWORD FOR 'root'@'localhost' = PASSWORD('your new password');

After completing the above steps, the password has been changed successfully. Now you can use the newly set password to log in to MySQL.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.