What to do if you forget the initial password of MySQL on MAC

The solution to forgetting the initial password of MySQL under MAC is shared with you for your reference. The specific content is as follows

After installing the MySQL dmg from the official website.

1 Set up mysql command

From the terminal, type

mysql --version

If the version number is displayed, it is normal; if it shows command not found, follow the code below to link the installation path

cd /usr/local/bin/
sudo ln -fs /usr/local/mysql/bin/mysql mysql

2. Shut down the mysql service

sudo /usr/local/mysql/support-files/mysql.server stop

3 Start mysql in safe mode

sudo /usr/local/mysql/bin/mysqld_safe --skip-grant-tables

Then open the system preferences, select mysql, and you will find the mysql service and restart it.

4 Return to the terminal

Command + N to reopen a terminal and enter

mysql -u root

At this time, you can directly enter mysql without a password, and you can modify any password.

5 Change the password in the new terminal

mysql> FLUSH PRIVILEGES;
mysql> SET PASSWORD FOR root@'localhost' = PASSWORD('123');
// You can also modify other passwords // Finally refresh mysql> FLUSH PRIVILEGES;

After that, you can log in to mysql with the new password.

For more information about MySQL password operations, please refer to the topic: MySQL password operations summary for learning.

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.