create/Drop database in MySQL?

 mysql> create database test1;

when you create DB on ,it will create directory under data with db name and under this Directory  all the tables will be added.

--------------

create database test1

--------------

Query OK, 1 row affected (0.00 sec)

mysql> SELECT schema_name FROM information_schema.schemata;

--------------

SELECT schema_name FROM information_schema.schemata

--------------

+------------------------+

| SCHEMA_NAME            |

+------------------------+

| mysql                  |

| information_schema     |

| performance_schema     |

| sys                    |

| aaabbbb_dba_management |

| aaabbbb_xxxxxxtdb      |

| xxxxxxt                |

| aaabbbb_xxxxxxtkdndb   |

| test3                  |

| test1                  |

+------------------------+

10 rows in set (0.00 sec)

mysql> drop database test1;

--------------

drop database test1

--------------

Query OK, 0 rows affected (0.01 sec)

mysql> SELECT schema_name FROM information_schema.schemata;

--------------

SELECT schema_name FROM information_schema.schemata

--------------

+------------------------+

| SCHEMA_NAME            |

+------------------------+

| mysql                  |

| information_schema     |

| performance_schema     |

| sys                    |

| aaabbbb_dba_management |

| aaabbbb_xxxxxxtdb      |

| xxxxxxt                |

| aaabbbb_xxxxxxtkdndb   |

| test3                  |

+------------------------+

9 rows in set (0.00 sec)