mysql5.7的一些日常操作

发布时间 2023-09-25 11:28:42作者: 邹姣姣

查看库
MySQL [mysql]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| auditlog |
| mysql |
| nacos_config |
| performance_schema |
| sys |
+--------------------+
6 rows in set (0.00 sec)

删除库auditlog
MySQL [mysql]> drop database auditlog;
Query OK, 1 row affected (0.02 sec)

删除多余用户