Linux/Mac MySQL forgot password command line change password method, mysql forgot password

Linux/Mac MySQL forgot password command line change password method, mysql forgot password

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 section describes how to change the password of a Linux/Mac MySQL command line that forgets the password. I hope it will be helpful to you. If you have any questions, please leave a message for me, the editor will reply to you in a timely manner. Thank you very much for your support for the help House website!