How to change MySQL password on Mac

When using the MySQL database on a Mac computer, sometimes you need to change your MySQL password. This may be because you have forgotten your password or want to make it more secure. This article will share how to change MySQL password on Mac.

The prerequisite for changing the MySQL password is that you must already know the current MySQL password. To change the MySQL password on Mac, you need to follow the following steps:

Step 1: Log in to MySQL

Open the Mac Terminal application and type the following command to log in to MySQL:

mysql -u root -p

This command will prompt you to enter your MySQL password. After entering your current password, you are logged in to the MySQL database.

Step 2: Change the password

After you log in to the MySQL database, you need to use the following command to change the password:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpassword');

Please note that in the above command, 'root' represents the username and 'localhost' represents your hostname. If you are connecting to another host, you can change 'localhost' to the host's IP address or hostname. 'newpassword' represents your new password. You need to change it to the actual value of your new password.

Step 3: Refresh permissions

After changing the password, you need to execute the following command to clear the current MySQL permission cache so that the new password will take effect:

FLUSH PRIVILEGES;

This command Tells MySQL to update its internal cache of permission information so that new passwords can be enforced.

Step 4: Exit MySQL

After changing the password and refreshing the permissions, you need to exit the MySQL database. Please type the following command when exiting:

quit;

Modification successful! You have successfully changed your MySQL password on Mac.

Summary

In this article, we covered how to change MySQL password on Mac. If you follow the steps above, you can easily change your MySQL password. Hope this article helps you!

The above is the detailed content of How to change MySQL password on Mac. For more information, please follow other related articles on the PHP Chinese website!