MySQL Server and MySQL Workbench Installation and Configuration

DB Architecture

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/

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

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.