Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to change the user password in MySQL". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

You can change the password of a user (such as "hunte") in MySQL in the following three ways:

> > >

# enter on the console

Bash$-u root mysql

# use mysql client program

Mysql > UPDATE user SET password=PASSWORD ("new password") WHERE user=hunte

Mysql > FLUSH PRIVILEGES

Mysql > QUIT

# enter on the console

Bash$ mysql-u root mysql

Mysql > SET PASSWORD FOR hunte=PASSWORD (new password)

Mysql > QUIT

# enter it directly on the console

Bash$ mysqladmin-u root "old password"new password"

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.