MySQL Change password, retrieve password

Root User For example

First, change the password

Method One: Outside the MySQL system, use mysqladmin

# mysqladmin-u root-p Password "test123"

Enter Password: "Enter the original password"

Method two: By logging into the MySQL system,

# mysql-uroot-p

Enter Password: "Enter the original password"

Mysql>use MySQL;

mysql> Update user Set Password=password ("test") where user= ' root ';

mysql> flush Privileges;

Mysql> exit;

Second, retrieve the password

# Mysqld_safe--skip-grant-tables &

&, that means running in the background, no longer running in the background, then open a terminal.

# MySQL

mysql> use MySQL;

mysql> UPDATE user SET Password=password ("test123") WHERE user= ' root ';

mysql> flush Privileges;

Mysql> exit;

# #本来mysql是不分大小写的, but this is the specific value of MySQL database that is modified in MySQL, to be noted.

This article is from the "Cock Silk counter attack" blog, please make sure to keep this source http://5731674.blog.51cto.com/5721674/1657632

MySQL Change password, retrieve password