1.
Install your environment
a. MySQL: https://dev.mysql.com/downloads/installer/
Note: select your OS (1), download the second one (2)
Run installation, during the installation you’ll be asked to create root user,
please, don’t forget to save password to be able to connect under this user in the
future.
b. MySQL Workbench: https://dev.mysql.com/downloads/workbench/
Run the download and install MySQL Workbench after .exe file installed.
c. Database: https://dev.mysql.com/doc/index-other.html
Please, find the archive, download it and unzip.
You’ll see following files
d. Connect from workbench to your MySQL:
Open MySQL Workbench
Click on “Add connection”
Input the name for your connection, click on “Test Connection”, You’ll need to
input your password to root user, after clicking on “OK” you should see that
connection successful.
Click OK.
e. Adding data to database:
Double click on new connection
Click on “Data export” (1), find sakila-schema.sql (2), go to the “Import Progress”
(3) and click on “Start Import”. Do the same steps for sakila-data.sql file.
f. Now you should see newly created database in your databases list. Try to run
SELECT statement on any table to make sure that data is also loaded.
