What should I do if I forget my password for Linux/Mac MySQL?
What should I do if I forget my password for Linux/Mac MySQL? Don't worry. The following describes how to change the password of a command line.
You must obtain the root permission for all prerequisites.
1. End the mysql process
// Linuxsudo services mysql stop // Macbrew services stop mysql
2. mysql background running
Mysqld_safe -- skip-grant-tables & mysql
& Indicates running in the background without opening a new terminal
3. Change the password
Use mysql; update user set password = password ("new password") where user = 'root'; flush privileges;
When you know the original password
Run the mysqladmin command on the command line.
Mysqladmin-u root-p oldpassword "newpassword"
Alternatively, you can directly change the password in the mysql database. For more information, see [Change Password]
The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.