How to use the MySQL command line to change the MySQL login password

This article will explain in detail how to use the MySQL command line to change the MySQL login password. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Use the MySQL command line to change the MySQL login password: first log in to the mysql database, then enter the command [mysql > SET PASSWORD = PASSWORD ('aa')], and write [mysql > SET PASSWORD =';] if you set the password to be empty.

Use the MySQL command line to change the MySQL login password:

Method 1:

Mysql admin-u username-p old password password new password

'u'is the abbreviation of username

'p'is the abbreviation of password.

Method 2:

Log in to the mysql database first

Then enter:

Mysql > SET PASSWORD = PASSWORD ('aa')

The password for logging in to the mysql database has been changed to 'aa'.

If you set the password to be empty, you can write:

Mysql > SET PASSWORD =''

At this time, the password for logging into the mysql database has been set to a password-free state, and you can log in directly without entering the password.

Method 3:

Log in to the mysql database first

Then enter:

Mysql > set password for root@localhost = pasword ('aa');.

The password for logging in to the mysql database has been changed to 'aa'.

If you set the password to be empty, you can write:

Mysql > set password for root@localhost =''

At this time, the password for logging into the mysql database has been set to a password-free state, and you can log in directly without entering the password.

On how to use the MySQL command line to change the MySQL login password to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.