MySQL password change

Http://www.dodiphp.cn/bbsCache/bbs_469.html

1. modify data in the database

Mysql-u root-P press ENTER

Enter Password

Mysql> User MySQL

Mysql> Select User, password from user; # view password

# It can be seen that the password is 41 BITs. It is not recommended to directly modify this table, but it can be modified using the function compute password.

Mysql> select password ('abc ');

# Be careful when changing the password to the calculated value based on specific conditions.

Mysql-u root-P press ENTER

Enter Password

Mysql> User MySQL

Mysql> Select User, password from user; # view password from: exam network-[examw. com]

# It can be seen that the password is 41 BITs. It is not recommended to directly modify this table, but it can be modified using the function compute password.

Mysql> select password ('abc ');

# Be careful when changing the password to the calculated value based on specific conditions.

2. Change the root password to yourpassword in the command line.

Mysqladmin-u root-P password yourpassword press ENTER


Enter the original password

Mysqladmin-u root-P password yourpassword press ENTER

Enter the original password

3. Use set password. For example, change the root password to yourpasswd:

Mysql> set password for root @ localhost = PASSWORD ('yourpasswd ');

Mysql> set password for root @ localhost = PASSWORD ('yourpasswd ');

4. Use Grant... identified. For example, change the root password to youpassword:

Mysql> grant usage on *. * to root @ localhost identified by 'yourpassword ';