MySQL: Steps for creating a DB

MySQL Installation

First you need to install the MySQL server on your local environment. As soon as the installation is finished, the server should be up and running.

MySQL WORKBENCH

I use MySQL WORKBENCH extensively for creating and managing easily all my databases. You must install MySQL WORKBENCH on your computer if you've not done that yet.

You can easily add a connection via this window :



Create Schema

  1. Add a new Model (File/New Model)
  2. Edit the default schema (On Physical Schemas, right click 'mydb')
  3. Change the schema name
  4. Add tables, views...

Forward Engineer to Database

We assume that your schema is ready to 'deploy' to your MySQL server.

  1. Click Database/Forward Engineer...
  2. Select your MySQL server
  3. Accept default options values
  4. Revue the SQL script to be executed
  5. Click next to continue
The database should have been successfully created on your MySQL server.

Adding administrator for the created database

Open your MySQL server instance on MySQL WORKBENCH :

Run this script for adding an administrative user for the selected database:


As you can see, the user can only access the car_db database.

Comments

Post a Comment

Popular posts from this blog

Spring JPA : Using Specification with Projection

You may probably know that using Specification with Projection is not possible at this moment. I'll show you how you can easily bypass this problem using the JPA Criteria. 1. Create an extended repository We begin by creating an extending global repository as follow : You can find more information here . 2. Add our custom method In order to limit the fields returned for each item, the consumer of my API must provide the required fields this way: /orders?fields=productId,name,quantity . ( Best Practices ) Basically, I'm defining the SELECT clause with the returned fields (cf. getSelections() ): 😎Happy coding...
Read more

Chip input using Reactive Form

The Chips component documentation from the angular material website, describes how to use the MatChipInput directive with a chip-list for adding or removing chips. I'll show you how you can implement the same component using Reactive Form. The HTML template: The TS component file:   As you can see, we use the FormBuilder class to simplify the form creation. We define our requirements as a  FormArray within our FormGroup. The requirements will be accessed in our template with this expression inside the *ngFor of <mat-chip></mat-chip> : *ngFor="let requirement of form.get('requirements').controls; let i = index;" In the ChipComponent class, the requirements array is accessed by using this expression: this.form.get('requirements') as FormArray; Thanks
Read more