Create a new database with MySQL Workbench

MysqlDatabaseMysql Workbench

Mysql Problem Overview

Being new to MySQL, I have installed the latest version of the MySQL Workbench (5.2.33). I would like to know how you can create a database with this application. In the Overview tab of the SQL editor there are few "MySQL Schema" displayed, are these schemas the existing databases?

Mysql Solutions

Solution 1 - Mysql

  1. Launch MySQL Workbench.
  2. On the left pane of the welcome window, choose a database to connect to under "Open Connection to Start Querying".
  3. The query window will open. On its left pane, there is a section titled "Object Browser", which shows the list of databases. (Side note: The terms "schema" and "database" are synonymous in this program.)
  4. Right-click on one of the existing databases and click "Create Schema...". This will launch a wizard that will help you create a database.

If you'd prefer to do it in SQL, enter this query into the query window:

CREATE SCHEMA Test

Press CTRL + Enter to submit it, and you should see confirmation in the output pane underneath the query window. You'll have to right-click on an existing schema in the Object panel and click "Refresh All" to see it show up, though.

Solution 2 - Mysql

Click the database symbol with the plus sign (shown in the below picture). Enter a name and click Apply.

Add new database

This worked in MySQL Workbench 6.0

Solution 3 - Mysql

How to create database in MySQL Workbench 6.3

  1. In tab home (1) -> Right click on Local instance banner (2) -> Open Connection (3) enter image description here
  2. Right click on the empty space in schema window (1) -> Create schema (2) enter image description here
  3. Type name of database (1) -> Apply (2) enter image description here

Solution 4 - Mysql

In MySQL Work bench 6.0 CE.

  1. You launch MySQL Workbench.
  2. From Menu Bar click on Database and then select "Connect to Database"
  3. It by default showing you default settings other wise you choose you host name, user name and password. and click to ok.
  4. As in above define that you should click write on existing database but if you don't have existing new database then you may choose the option from the icon menu that is provided on below the menu bar. Now keep the name as you want and enjoy ....

Solution 5 - Mysql

Those who are new to MySQL & Mac users; Note that, Connection is different than Database.

Steps to create a database.

Step 1: Create connection and click to go inside

Step 1

Step 2: Click on database icon

Step 2

Step 3: Name your database schema

Step 3

Step 4: Apply query

Step 4

Step 5: Your DB created, enjoy...

Step 5

Solution 6 - Mysql

If the create new schema icon is disabled in the workbench, it means that your MySQL service is not running.

enter image description here

Please check if your MySQL service is running in the task manager.

enter image description here

Solution 7 - Mysql

you can use this command :

CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
  [create_specification] ...

create_specification:
    [DEFAULT] CHARACTER SET [=] charset_name
    | [DEFAULT] COLLATE [=] collation_name

Solution 8 - Mysql

This answer is for Ubuntu users looking for a solution without writing SQL queries.

The following is the initial screen you'll get after opening it

Initial screen

In the top right, where it says Administration, click in the arrow to the right

From Administration to Schemas

This will show Schema (instead of Administration) and it's possible to see a sys database.

Schema menu with databases

Right click in the grey area after functions and click Create Schema...

Create Schema

This will open the following where I'm creating a table named StackOverflow_db

Create new Schema

Clicking in the bottom right button that says "Apply",

Create a new Schema in Workbench

And in this new view click in "Apply" too. In the end you'll get a database called StackOverflow_db

Database created

Solution 9 - Mysql

For me there was a weird bug in Workbench where I had to click the icon multiple times until the "Apply" and "Revert" buttons showed

enter image description here

Solution 10 - Mysql

first, you have to create Models. default model is sakila, so you have to create one. if you already created the new one, go to Database > Forward Engineer. then, your model will exist in local instance:80

Forward engineer is to create database in your choosed host!

Categories
Recommended Mysql Solutions
Recommended Database Solutions
Recommended Mysql Workbench Solutions

Previous Solution:

Using jquery to get all checked checkboxes with a certain class name

JqueryJquery SelectorsCheckbox

Next Solution:

Transposing a 1D NumPy array

PythonNumpyTranspose

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionAntView Question on Stackoverflow
Solution 1 - MysqlZach RattnerView Answer on Stackoverflow
Solution 2 - MysqlSaiyanGirlView Answer on Stackoverflow
Solution 3 - MysqlфымышонокView Answer on Stackoverflow
Solution 4 - MysqlMuhammad Rizwan Kaim KhaniView Answer on Stackoverflow
Solution 5 - MysqlMohammad Zaid PathanView Answer on Stackoverflow
Solution 6 - MysqlSumanthKetheView Answer on Stackoverflow
Solution 7 - Mysqlomid haghighatgooView Answer on Stackoverflow
Solution 8 - MysqlTiago Martins PeresView Answer on Stackoverflow
Solution 9 - MysqlUriahs VictorView Answer on Stackoverflow
Solution 10 - MysqlJetwizView Answer on Stackoverflow