In the tab that appears double-click on the add diagram icon pointed to by an arrow in the image above. In the tab that opens, click on file in the menu bar and select New Model or use the shortcut Ctrl + N. To do this open the my_tutorial connection we created a minute ago. We are going to create a data model for a small school database. Now it is time for us to create a simple data model. And there you have you just created a connection to a MySQL server. All we are going to add is the connection name and just leave the other fields as they are and then click OK to create the connection my_tutorial. In the dialog box that appears we have to fill in some input fields. This opens the Set New Connection Dialog Box. To create a new connection to the MySQL server click on the small plus button pointed to be the blue arrow in the above image. This is how the homepage looks on windows. To do this click the start button pointed to by the arrow in the picture below.Ĭlicking on that button starts running MySQL server. The first step is launching the XAMPP control panel and starting the MySQL server.
#DATABASE WORKBENCH DATA MODELING HOW TO#
To top it all up, we are going to end with learning how to add data to a database so buckle up and lets get started. We will look at how to create a simple data model with Workbench. Our focus will be creating a connection to a local server though. This will be done in three sections.įirstly how to create a connection to a server (local or remote server). Checkout how to install XAMPP here.Īfter all is said and done, we are now going to see how to use MySQL Workbench. We need to have XAMPP( a free and open-source cross-platform web server solution stack package developed by Apache Friends) downloaded and installed too. The version at the time of this writing is version 8.0.22 You can checkout my step-by-step tutorial on how to download and install Workbench for windows here.
To be able to follow this tutorial smoothly, you are going to need the following software
#DATABASE WORKBENCH DATA MODELING FOR MAC OS#
Workbench is available for mac OS and Linux as well. This tutorial is done using the community version of Workbench for windows. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. It is a visual tool for database architects, developers, and database administrators. This post is a tutorial on how to get started with MySQL Workbench which is a GUI (Graphical User Interface) for MySQL.