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, 1369🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...