Shulou(Shulou.com)06/01 Report--

This article mainly introduces the methods to modify the mysql password, the article is very detailed, has a certain reference value, interested friends must read it!

How to change the mysql password?

How to change the mysql password:

Method 1: use the SET PASSWORD command

Log in to MySQL first.

Format: mysql > set password for username @ localhost = password ('new password')

Example: mysql > set password for root@localhost = password ('123')

Method 2: use mysqladmin

Format: mysqladmin-u username-p old password password new password

Example: mysqladmin-uroot-p123456 password 123

Method 3: edit the user table directly with UPDATE

Log in to MySQL first.

Mysql > use mysql; mysql > update user set password=password ('123') where user='root' and host='localhost'; mysql > flush privileges; all of the above are the ways to change the mysql password. Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.