How to create new database with MySQL Workbench - MySQL DBA Tutorial

How to create new database with MySQL Workbench



There are couple of days to create new database or schema in MySQL Server by using MySQL Workbench.

  1. You can open a new query and type the statement "create database new_db_name". It will create the database in MySQL with default collation and characters sets.
  2. Second way to create the new Schema/ Database in MySQL is , Right click on any existing Schema and then choose Create Schema, Provide the name for new Schema and select Collation and Characters Set. Hit apply and new Schema/ Database will be created.

How to create database in MySQL Server by using MySQL Workbench

2 comments: