Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Change the Password of Another User Account
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: FYIcenter.com
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)
2007-05-10, 6760👍, 0💬
Popular Posts:
What is shadowing ? When two elements in a program have same name, one of them can hide and shadow t...
What does static variable mean? There are 3 main uses for static variables: If you declare within a ...
Do You Know the Book "JUnit in Action"? You should know this book. It received some good reviews. Ti...
How To Fade Image Edges to Background Colors? - PSP Tutorials - Fading Images to Background Colors w...
What is ISO? ISO 9000 is a family of standards for quality management systems. ISO 9000 is maintaine...