Collections:
Deleting a User Account in MySQL
How To Delete a User Account in MySQL?
✍: 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)
⇒ Listing All User Accounts in MySQL
⇐ Chaning Other User's Password in MySQL
2017-12-13, 1891🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...