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?
This question is related to
mysql
database
mysql-workbench
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
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
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
In MySQL Work bench 6.0 CE.
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!
Source: Stackoverflow.com