Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Change the Password for Your Own User Account
How To Change the Password for Your Own User Account? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: FYIcenter.com
If you want to change the password of your own user account, you should use your user account connect to the server "mysql" first. You should then use the "SET PASSWORD ..." command to change the password of the current user account. There are two ways to use this command to set a new password and store it in an encrypted format:
SET PASSWORD = 'encryptedPasswordString'; SET PASSWORD = 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 mysql mysql> SET PASSWORD = 'retneciyf'; ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number mysql> SET PASSWORD = PASSWORD('retneciyf'); Query OK, 0 rows affected (0.56 sec) mysql> SELECT User, Password, Shutdown_priv FROM user; +------+-------------------------------------------+-----+ | User | Password | ... | +------+-------------------------------------------+-----+ | root | *3735F1D8464342BA852E10101E55E422EBAAAF35 | Y | | dev | *3735F1D8464342BA852E10101E55E422EBAAAF35 | N | +------+-------------------------------------------+-----+ 2 rows in set (0.00 sec)
2007-05-10, 4901👍, 0💬
Popular Posts:
1. The basics first, please define the web in simple language? How is it connected with internet? Wh...
How do I force the Dispose method to be called automatically, as clients can forget to call Dispose ...
How to measure functional software requirement specification (SRS) documents? Well, we need to defin...
How To Recover a Dropped Index? - Oracle DBA FAQ - Managing Oracle Table Indexes If you have the rec...
Can JavaScript steal text from your clipboard? It is true, text you last copied for pasting (copy &a...