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, 3044🔥, 0💬
Popular Posts:
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Get the Definition of a Stored Procedure Back in SQL Server Transact-SQL? If you want get the...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...