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

MySQL provides a variety of ways to change your account password:

1. You can use the mysqladmin command to specify a password on the command line

Shell > mysqladmin-u user_name-h host_name password "newpwd" this command resets the account of the password to the user_name and Host columns in the user table that match the user_name and Host columns of the client to which you initiated the connection.

For example, change the password to: root123 [root@mysql1 ~] # mysqladmin-u root password "root123"-p Enter password:-- you need to enter the old password here

2. Another way to assign a password to an account is to execute the SET PASSWORD statement

Mysql > SET PASSWORD FOR 'jeffrey'@'%' = PASSWORD (' biscuit')

Only users such as root who can update the mysql database can change the passwords of other users. If you do not connect as an anonymous user, you can change your password by omitting the FOR clause:

Mysql > set password = password ('mysql'); Query OK, 0 rows affected (0.01 sec)

Mysql > exit Bye [root@mysql1 ~] # mysql-uroot-p Enter password:-- enter the old password with the following prompt: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) [root@mysql1 ~] # mysql-uroot-p Enter password:-- enter the new password to connect Welcome to the MySQL monitor successfully. Commands end with; or\ g. Your MySQL connection id is 11 Server version: 5.6.30 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement.

Mysql >

3. You can use the GRANT USAGE statement (in *. *) at the global level to specify the password of an account without affecting the current permissions of the account.

Mysql > GRANT USAGE ON *. * TO 'jeffrey'@'%' IDENTIFIED BY' biscuit'

In general, it is best to use the above three methods to specify the password. You can also modify the user table directly:

To establish a password when creating a new account, provide a value in the Password column:

Shell > mysql-u root mysql mysql > INSERT INTO user (Host,User,Password)-> VALUES ('%', 'jeffrey',PASSWORD (' biscuit')); mysql > FLUSH PRIVILEGES

To change the password of an existing account, use UPDATE to set the Password column value:

Shell > mysql-u root mysql mysql > UPDATE user SET Password = PASSWORD ('bagel')-> WHERE Host ='% 'AND User =' francis'; mysql > FLUSH PRIVILEGES; when you use the password for an account specified by SET PASSWORD, INSERT or UPDATE, you must encrypt it with the PASSWORD () function. (the only exception is that you don't need to use PASSWORD () if the password is empty.) You need to use PASSWORD () because the user table holds the password in encrypted form, not in clear text. If you forget, you may set your password like this:

Shell > mysql-u root mysql mysql > INSERT INTO user (Host,User,Password)-> VALUES ('%', 'jeffrey','biscuit'); mysql > FLUSH PRIVILEGES

The result is that the password 'biscuit' is not encrypted after it is saved to the user table. When jeffrey uses this password to connect to the server, the value is encrypted and compared with what is saved in the user table. However, the saved value is the string 'biscuit', so the comparison will fail, and the server rejects the connection:

Shell > mysql-u jeffrey-pbiscuit test Access denied if you use GRANT. The IDENTIFIED BY statement or the mysqladmin password command sets the password, which encrypts the password. In this case, you do not need to use the PASSWORD () function.

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.