MySQL Workbench Create, Alter, Drop Database
In this video we will learn How to Create, Alter and Drop database using MySQL Workbench. Open MySQL Workbench and logged in to MySQL database server using 'root' username and password. In the left hand column window, under 'Schemas' menu, To create a new database, right click the 'schemas' area and select 'Create Schema' menu. OR from the top window toolbars, select this 'database' icon. In new schema window screen enter the new database name. Click 'apply' button which pops up a SQL script window. Click apply and finish to create the new database.
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 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.