Create a new database with MySQL Workbench

Question

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

User · Answer

In MySQL Work bench 6 0 CE    You launch MySQL Workbench  From Menu Bar click on Database and then select  Connect to Database  It by default showing you default settings other wise you choose you host name  user name and password  and click to ok  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

User · Answer

Launch MySQL Workbench  On the left pane of the welcome window  choose a database to connect to under  Open Connection to Start Querying   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   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

User · Answer

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

User · Answer

How to create database in MySQL Workbench 6 3   In tab home  1  -  Right click on Local instance banner  2  -  Open Connection  3   Right click on the empty space in schema window  1  -  Create schema  2    Type name of database  1  -  Apply  2

User · Answer

Click the database symbol with the plus sign  shown in the below picture   Enter a name and click Apply      This worked in MySQL Workbench 6 0

User · Answer

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    In the top right  where it says Administration  click in the arrow to the right    This will show Schema  instead of Administration  and it s possible to see a sys database     Right click in the grey area after functions and click Create Schema       This will open the following where I m creating a table named StackOverflow db    Clicking in the bottom right button that says  Apply      And in this new view click in  Apply  too  In the end you ll get a database called StackOverflow db

User · Answer

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

User · Answer

Those who are new to MySQL  amp  Mac users  Note that  Connection is different than Database   Steps to create a database   Step 1  Create connection and click to go inside    Step 2  Click on database icon    Step 3  Name your database schema    Step 4  Apply query    Step 5  Your DB created  enjoy

[mysql] Create a new database with MySQL Workbench

Examples related to mysql

Examples related to database

Examples related to mysql-workbench