How to change the MySQL password in the MySQL command line

This article mainly introduces the relevant knowledge of "how to change the MySQL password on the MySQL command line". The editor shows you the operation process through an actual case. The operation method is simple, fast and practical. I hope this article "how to change the MySQL password on the MySQL command line" can help you solve the problem.

Method 1: mysql admin-u username-p old password passw new password

'u'is the abbreviation of username, and'p'is the original abbreviation of password.

Method 2:

Let's log in to the MySQL database first. Then enter:

Mysql > set password for root@localhost = pasword ('w3ccargo')

Or

Mysql > SET PASSWORD = PASSWORD ('w3ccargo')

At this time, the password has been changed to 'w3csubscription'.

If you want to set the password to empty, you need to write the following code:

Mysql > set password for root@localhost =''

Or

Mysql > SET PASSWORD =''

At this point, the login password has been set to empty, and we can log in directly without entering the password.

This is the end of the introduction on "how to change the MySQL password on the MySQL command line". Thank you for reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.