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

The way Mysql changes passwords

If you forget your password-- skip-grant-tables

1 、 alter user

Alter user test@'localhost' identified by 'xxxxx'

2 、 grant

Show grants for test@'localhost';GRANT USAGE ON *. * TO 'test'@'localhost' IDENTIFIED BY PASSWORD' * xxxxxxxxxxxxx'

GRANT USAGE ON *. * TO 'test'@'localhost' IDENTIFIED BY' xxxxxxxxxxxxx'

3 、 set password

Set password for test@'localhost'=password ('xxx')

4 、 update mysql.user

Mysql > UPDATE mysql.user SET Password = PASSWORD ('newpass') WHERE user =' test' and host='localhost';mysql > FLUSH PRIVILEGES

5 、 mysqladmin

Mysqladmin-u test password "newpass" # set mysqladmin-u test password oldpass "newpass" for the first time # if root has already set a password, use the following method

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.