DB Architecture
Client Side
Server Side
Localhost: 127.0.0.1
MySQL Workbench
MySQL Server 8.0.12
Task 1: MySQL Community Server Installation and Configuration
Download: https://dev.mysql.com/downloads/mysql/
Documentation: https://dev.mysql.com/doc/refman/8.0/en/
- Use Legacy Password Encryption
- You can create your own password of the Root user and please REMEMBER your password.
Basic MySQL Command Summary
- Open the Terminal/Command Prompt and run the following commands:
mysql -u root -p - h localhost
show databases ;
use [database_name] ;
show tables ;
describe [table_name] ;
select * from mysql.user \G
show grants for 'root'@'localhost' ;
exit
Task 2: MySQL Workbench Installation and Configuration
Task 2.1: Installing
Download: https://dev.mysql.com/downloads/workbench/
Source: https://dev.mysql.com/doc/workbench/en/wb-installing.html
- Three Modules
SQL Development
Data Modelling
Migration Wizard
Task 2.2: Creating A New MySQL Connection
Tutorial: https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-createconnection.html
Task 3: Creating a new database named “classicmodels”
Source: https://www.mysqltutorial.org/mysql-sample-database.aspx
The classicmodels database is a retailer of scale models of classic cars database. It contains typical business data such as customers, products, sales orders, sales order line items, etc.
Download and run a script named “mysqlsampledatabase.sql” from MS teams/LEB2
Try to type SQL statement to retrieve data from the Classicmodels database.
