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 Delete a User Account
How To Delete a User Account? - MySQL FAQs - Managing User Accounts and Access Privileges
✍: FYIcenter.com
If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example:
>cd \mysql\bin >mysql -u root -pretneciyf mysql mysql> SELECT User, Password, Shutdown_priv FROM user; +------+-------------------------------------------+-----+ | User | Password | ... | +------+-------------------------------------------+-----+ | root | *3735F1D8464342BA852E10101E55E422EBAAAF35 | Y | | dev | *446BD97F308FBA0B9CBDC962C2842AD338BCE59E | N | +------+-------------------------------------------+-----+ 2 rows in set (0.01 sec) mysql> DROP USER dev; Query OK, 0 rows affected (0.63 sec) mysql> SELECT User, Password, Shutdown_priv FROM user; +------+-------------------------------------------+-----+ | User | Password | ... | +------+-------------------------------------------+-----+ | root | *3735F1D8464342BA852E10101E55E422EBAAAF35 | Y | +------+-------------------------------------------+-----+ 1 row in set (0.01 sec)
2007-05-10, 5246👍, 0💬
Popular Posts:
what are the advantages of hosting WCF Services in IIS as compared to self hosting? There are two ma...
What is the difference between mysql_fetch_object() and mysql_fetch_array() functions in PHP? mysql_...
Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...
What is the significance of Finalize method in .NET? .NET Garbage collector does almost all clean up...
Where are cookies actually stored on the hard disk? This depends on the user's browser and OS. In th...