Creating and Dropping Databases

Last modified: June 26, 2023

Database is MySQL schema object that represents a folder containing tables. Tables can not exist outside a database. In MySQL 3.23 database has only one property - Name. In the later versions of MySQL, Charset and Collation are added.

Creating a Database

1. In Database Explorer, right-click a connection node and select New Database.

   • or -

   Select New Database on the Database menu.

2. Input name of the database.
3. Select Character set and Collation.
4. Click OK, and, if specified name is unique, the database will appear in Database Explorer.

Editing a Database

1. In Database Explorer, right-click a database node and select Edit Database on the shortcut menu.
2. Select Character set and Collation.
3. Click Update Database.

Note

Database can be renamed only on MySQL 5.1.7 - 5.1.23 and 6.0.0. You can not rename database in other MySQL versions.

Dropping a Database

Drop a database by selecting Delete on the node shortcut menu.

Note

When you drop database all tables and data containing within it are lost.