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, 1379🔥, 0💬
Popular Posts:
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......