In this lecture we will Create, Alter and Drop database using MySQL Workbench. I’ve opened MySQL Workbench and logged in, in my MySQL database server using ‘root’ username and password. In the left hand column window, under ‘Schemas’ menu, We can see previously created databases and ‘sys’ database that is default system database for MySQL. To create a new database, right click under the ‘schemas’ area and select ‘Create Schema’ menu. OR from the top window toolbars, select this ‘database’ icon. In the new schema window screen enter the new database name. I’ll enter “mytestdb” and use default collation. The collection is used to store specific data character, mainly useful for storing foreign languages. Click this ‘apply’ button which pops up a SQL script window. Click apply and finish to create the new database. You can see the new database is listed under the ‘schemas’ menu. If you can not see the new database, click this refresh icon and reload the list. Select the new database and click this ‘i’ alphabet icon to display more information about the database. The information window displays several tabs like tables, columns, function and also the users who can access the database from ‘Grants’ tab. MySQL Workbench does not provide any option to rename the ‘database name’ but we can CREATE, UPDATE OR DELETE tables and data rows using MySQL Workbench tool. To drop a database, select the database name, from under ‘Schemas’ menu, right click and select drop schema option. Select the ‘drop now’ option from the popup window and the database including tables and data rows will be deleted from the database server.