Home >> FAQs/Tutorials >> MySQL Tutorials

MySQL Tutorial - Chaning Other User's Password

By: FYIcenter.com

(Continued from previous topic...)

How To Change the Password of Another User Account?

If you want to change the password of someone else's user account, you can connect to the server as "root" and use the "SET PASSWORD FOR userName ..." command to change the password of another user account. There are two ways to use this command to set a new password and store it in an encrypted format:

SET PASSWORD FOR userName = 'encryptedPasswordString';
SET PASSWORD FOR userName = PASSWORD('passwordString');

Notice that PASSWORD() is a system function to encrypt the specified password. Here is good tutorial exercise to show you how to set a new password:

>cd \mysql\bin
>mysql -u root -pretneciyf mysql

mysql> SET PASSWORD FOR dev = 'iyf';
ERROR 1372 (HY000): Password hash should be a 41-digit 
 hexadecimal number

mysql> SET PASSWORD FOR dev = PASSWORD('iyf');
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT User, Password, Shutdown_priv FROM user;
+------+-------------------------------------------+-----+
| User | Password                                  | ... |
+------+-------------------------------------------+-----+
| root | *3735F1D8464342BA852E10101E55E422EBAAAF35 | Y   |
| dev  | *446BD97F308FBA0B9CBDC962C2842AD338BCE59E | N   |
+------+-------------------------------------------+-----+
2 rows in set (0.00 sec)

(Continued on next topic...)

  1. What Is a User Account?
  2. What Are the Predefined User Accounts?
  3. How To Add a New User Account?
  4. How To Test a New User Account and Password?
  5. How To Change the Password for Your Own User Account?
  6. How To Change the Password of Another User Account?
  7. How To Delete a User Account?
  8. How To List All Existing User Accounts?
  9. How To Rename an Existing User Account Name?
  10. What Are User Privileges?
  11. How Many Scope Levels Can User Privileges Apply?
  12. How To Grant User Privileges at the Global Level?
  13. How To Grant User Privileges at the Database Level?
  14. How To View User Privileges?
  15. How To Revoke User Privileges?
  16. How To Give a User Read-Only Access to a Database?
  17. Where Are User Privileges Stored on the Server?

MySQL Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...