MySQL CLI and Workbench - Step-by-Step Execution

Concept Flow - MySQL CLI and Workbench

Start MySQL CLI or Workbench

↓

Connect to MySQL Server

↓

Enter SQL Query

↓

Send Query to Server

↓

Server Executes Query

↓

Receive Results

↓

Display Results in CLI or Workbench

↓

Repeat or Exit

This flow shows how you start MySQL CLI or Workbench, connect to the server, run queries, and see results.

Execution Sample

MySQL

mysql -u root -p
SHOW DATABASES;
USE testdb;
SHOW TABLES;

This example connects to MySQL CLI, lists databases, switches to 'testdb', and lists its tables.

Execution Table

Step	Action	Input/Command	Server Response	Output Displayed
1	Start MySQL CLI	mysql -u root -p	Prompt for password	Password prompt shown
2	Enter password	******	Connected to MySQL Server	Welcome message and prompt shown
3	List databases	SHOW DATABASES;	List of databases	Databases displayed in table format
4	Select database	USE testdb;	Database changed	Confirmation message shown
5	List tables	SHOW TABLES;	List of tables in testdb	Tables displayed in table format
6	Exit CLI	exit	Connection closed	CLI exits
7	Start Workbench	Open MySQL Workbench app	Workbench interface loads	GUI ready for queries
8	Connect to server	Select connection and connect	Connected to MySQL Server	Server schemas shown
9	Run query	SHOW DATABASES;	List of databases	Databases shown in Results tab
10	Run query	USE testdb;	Database changed	Status message shown
11	Run query	SHOW TABLES;	List of tables	Tables shown in Results tab
12	Close Workbench	Close app	Disconnected	Workbench closes

💡 User exits CLI or closes Workbench, ending the session.

Variable Tracker

Variable	Start	After Step 3	After Step 4	After Step 5	After Step 9	After Step 10	After Step 11	Final
Current Database	None	None	testdb	testdb	None	testdb	testdb	None
Connection Status	Disconnected	Connected	Connected	Connected	Connected	Connected	Connected	Disconnected

Key Moments - 3 Insights

Why do I need to enter a password after starting MySQL CLI?

The password prompt appears at Step 1 because MySQL requires authentication to connect to the server, ensuring only authorized users access the database.

What does the 'USE testdb;' command do?

At Step 4 and Step 10, 'USE testdb;' changes the current database context so that subsequent queries run on 'testdb'. Without this, queries might run on the default or previous database.

Why do results appear differently in CLI and Workbench?

Steps 5 and 11 show that CLI displays results as text tables in the terminal, while Workbench shows results in a graphical Results tab, making it easier to read and interact with.

Visual Quiz - 3 Questions

Look at the execution table at Step 3. What is the server response after running 'SHOW DATABASES;'?

A List of databases

B Database changed

C Connection closed

D Password prompt

💡 Hint

Check the 'Server Response' column for Step 3 in the execution table.

At which step does the current database change to 'testdb' in the variable tracker?

A After Step 3

B After Step 4

C After Step 5

D After Step 9

💡 Hint

Look at the 'Current Database' row in the variable tracker after each step.

If you skip entering the password at Step 2, what would happen?

A You would connect without password

B Server would list databases anyway

C Connection to MySQL Server would fail

D CLI would exit automatically

💡 Hint

Refer to Step 1 and 2 in the execution table about authentication.

Concept Snapshot

MySQL CLI and Workbench let you connect to MySQL Server.
Start CLI with 'mysql -u user -p' and enter password.
Use 'SHOW DATABASES;' to list databases.
Use 'USE dbname;' to select a database.
Workbench provides a GUI for running queries and viewing results.
Exit CLI with 'exit' or close Workbench to disconnect.

Full Transcript

This lesson shows how to use MySQL CLI and Workbench to connect to a MySQL server, run queries, and see results. First, you start the CLI or open Workbench. Then you connect by entering your username and password. After connection, you can list databases with 'SHOW DATABASES;'. To work in a specific database, use 'USE databasename;'. You can then list tables with 'SHOW TABLES;'. CLI shows results as text, while Workbench shows them graphically. Finally, you exit the CLI with 'exit' or close Workbench to end the session.