Common Administration Commands
Show list of users,
| Code Block | ||
|---|---|---|
| ||
select User from mysql. |
...
user;
+------------------+
| User |
+------------------+
| root |
| root |
| debian-sys-maint |
| root |
+------------------+ |
Drop a user, changing name to the matching name,
| Code Block | ||
|---|---|---|
| ||
delete from mysql.user WHERE User='name'; |