Page 74 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

EXERCISE 20 : Creating and Using a Database in MySQL

Objectives

At the end of this exercise you shall be able to
• create the database & use it
• create the table and use it & perform insert ,Select,update and delete queries

Requirements

Tools/Materials
• Operating System: Windows 10 or 11 (64-bit)
• MySQL Setup Software
• Desktop/Laptop will latest configuration

Procedure

TASK 1 : Creating and Using a Database in MySQL

1 Open the MySQL Command Line Client:
Windows: Search for “MySQL Shell” or “mysql.exe” in the Start menu.
macOS/Linux: Open a terminal and type mysql (if installed globally) or path/to/your/mysql/bin/mysql.

2 Connect to the MySQL Server:
Type mysql -u root -p
Enter your root password when prompted.

59