1. show 显示所有的数据库和所有的表命令如下：

show databases;
show tables;

操作如下：

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| lollic6_magento    |
| mysql              |
| performance_schema |
| phpmyadmin         |
+--------------------+
5 rows in set (0.00 sec)

mysql> use lollic6_magento;
Database changed
mysql> show tables;
+--------------------------------------------------+
| Tables_in_lollic6_magento                        |
+--------------------------------------------------+
| admin_assert                                     |
| admin_role                                       |
| admin_rule                                       |

2. 显示 mysql进程  show processlist;

show processlist;

首先需要选中某一个数据库,操作如下：

mysql > show processlist;