Home:ALL Converter>Create a new database with MySQL Workbench

Create a new database with MySQL Workbench

Ask Time:2011-04-01T23:49:54         Author:Ant

Json Formatter

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?

Author:Ant,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/5515745/create-a-new-database-with-mysql-workbench
Zach Rattner :

\nLaunch MySQL Workbench.\nOn the left pane of the welcome window, choose a database to connect to under \"Open Connection to Start Querying\".\nThe 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.)\nRight-click on one of the existing databases and click \"Create Schema...\". This will launch a wizard that will help you create a database. \n\n\nIf you'd prefer to do it in SQL, enter this query into the query window:\n\nCREATE SCHEMA Test\n\n\nPress 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.",
2011-04-01T16:49:19
SaiyanGirl :

Click the database symbol with the plus sign (shown in the below picture). Enter a name and click Apply. \n\n\n\nThis worked in MySQL Workbench 6.0 ",
2014-03-04T06:06:52
фымышонок :

How to create database in MySQL Workbench 6.3\n\n\nIn tab home (1) -> Right click on Local instance banner (2)\n-> Open Connection (3)\n\nRight click on the empty space in schema window (1) -> Create schema (2)\n \nType name of database (1) -> Apply (2)\n\n",
2016-10-21T15:48:55
Muhammad Rizwan Kaim Khani :

In MySQL Work bench 6.0 CE.\n\n\nYou launch MySQL Workbench.\nFrom Menu Bar click on Database and then select \"Connect to Database\"\nIt by default showing you default settings other wise you choose you host name, user name and password. and click to ok.\nAs 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 ....\n",
2013-10-22T09:52:40
Mohammad Zaid Pathan :

Those who are new to MySQL & Mac users; Note that, Connection is different than Database.\n\nSteps to create a database.\n\nStep 1: Create connection and click to go inside\n\n\n\nStep 2: Click on database icon\n\n\n\nStep 3: Name your database schema\n\n\n\nStep 4: Apply query\n\n\n\nStep 5: Your DB created, enjoy...\n\n",
2020-03-30T19:10:10
SumanthKethe :

If the create new schema icon is disabled in the workbench, it means that your MySQL service is not running.\n\nPlease check if your MySQL service is running in the task manager.\n",
2021-07-05T19:46:31
Tiago Martins Peres :

This answer is for Ubuntu users looking for a solution without writing SQL queries.\n\nThe following is the initial screen you'll get after opening it\n\n\n\nIn the top right, where it says Administration, click in the arrow to the right\n\n\n\nThis will show Schema (instead of Administration) and it's possible to see a sys database.\n\n\n\nRight click in the grey area after functions and click Create Schema...\n\n\n\nThis will open the following where I'm creating a table named StackOverflow_db\n\n\n\nClicking in the bottom right button that says \"Apply\",\n\n\n\nAnd in this new view click in \"Apply\" too. In the end you'll get a database called StackOverflow_db\n\n",
2020-06-02T11:35:32
omid haghighatgoo :

you can use this command :\n\nCREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name\n [create_specification] ...\n\ncreate_specification:\n [DEFAULT] CHARACTER SET [=] charset_name\n | [DEFAULT] COLLATE [=] collation_name\n",
2014-03-18T06:58:52
Uriahs Victor :

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\n",
2021-05-26T23:33:37
yy