The diagram is in the EER tab of MySQL workbench. Once the process completes, you can see the schema diagram of the sakila database that has been created. On the Reverse Engineering Result screen, you can see the details of the reverse-engineered objects. If it encounters any error, it will be displayed on the Reverse engineering process screen. The reverse engineering process on the database starts.

We want to generate the diagram of the tables hence select Import MySQL table object and click on Execute. On Select objects to Reverse Engineer screen, you can choose the objects which you want to reverse engineer. If any occurs, which fetching the object, it displays on the screen. On retrieve and reverse engineer schema object screen, the wizard populates the schema object to the sakila database. We want to generate the schema of the sakila database hence, click on sakila and click on Next. The wizard will generate the schema diagram of the selected database. On the Select Schemas to Reverse Engineer screen, you can choose the database.

The connection is established successfully. If it fails, then the error will be shown on Connect to DBMS and fetch the information screen. Now, MySQL database server tries to establish the connection between the reverse engineering wizard and server and fetch the information of the database hosted on the server. And finally, enter the appropriate user name in the Username text box and click on Next. Enter the appropriate port number in Port Number text box. Enter hostname or IP Address in the Hostname text box. On the Reverse Engineer Database screen, choose the connection name from the Stored Connection drop-down box, choose the appropriate connection method ( TCP/IP OR Named Pipe) from Connection Method drop-down box. To generate the schema diagram, Open MySQL workbench -> Connect to MySQL database engine -> From the menu bar, click on the database -> Select Reverse Engineer. Now to understand the schema architecture of the tables of the sakila, we will generate a schema diagram by reverse-engineering the database. You can download the sakila database from here, and the installation steps are provided in this article. This article helps you to install the MySQL server on Windows 10. In this article, I am going to explain how we can query the data from the MySQFL server using the SELECT statement.įor the demonstration, I have installed MySQL 8.0 and MySQL Workbench on my workstation and also restored a demo database named sakila. In this series of articles, we are going to learn about the basics of the MySQL database server.

Sakila database demo