MySQL Workbench Create, Alter, Drop Database

MySQL Workbench Create, Alter, Drop Database

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.

Danny Hutson

5 thoughts on “MySQL Workbench Create, Alter, Drop Database

  1. I would recommend the users to follow this tutorial , if you don not have any idea what is a database server and how you should operate on it. These are the amazing beginners sessions . Thank You sir , these are awesome.

  2. This is how to teach any beginner properly. Most other uploaders should learn from this video. It seems to be a common problem for some programmers beeing incompetent as teachers. You need to think like a human, not like a computer. If you're having a hard time understanding the indian accent for some reason, the subtitles works well!

Leave a Reply

Your email address will not be published. Required fields are marked *