Mysql ubuntu shell 用户删除 数据库删除

shell里面输入
mysql -u root -p
输入密码
mysql> SELECT User, Host FROM mysql.user;
可罗列所有用户，如下

+------------------+-----------+
| User             | Host      |
+------------------+-----------+
| debian-sys-maint | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| root             | localhost |
| seafile          | localhost |
+------------------+-----------+

mysql> DROP USER 'seafile'@'localhost';
可删除seafile用户
mysql> SHOW DATABASES;
可罗列所有数据库，示例如下

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| ccnet-db           |
+--------------------+

mysql> DROP DATABASE `ccnet-db`;

带-短横的名字要用撇号括起来。