MySQL CLI and Workbench - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the MySQL CLI?

The MySQL CLI (Command Line Interface) is a text-based tool where you type commands to interact with the MySQL database directly.

beginner

What is MySQL Workbench used for?

MySQL Workbench is a graphical tool that helps you design, manage, and query MySQL databases using a visual interface instead of typing commands.

beginner

How do you connect to a MySQL server using the CLI?

You use the command: mysql -u username -p and then enter your password when prompted.

beginner

Name one advantage of using MySQL Workbench over the CLI.

Workbench shows database structure visually, making it easier to understand tables and relationships without memorizing commands.

beginner

How do you exit the MySQL CLI?

Type exit; or quit; and press Enter to leave the MySQL CLI.

Which command starts the MySQL CLI?

A mysql connect

B workbench start

C start mysql

D mysql -u username -p

The correct command to start the MySQL CLI is mysql -u username -p.

What does MySQL Workbench provide that CLI does not?

A Ability to run SQL queries

B Graphical interface to manage databases

C Command line access

D Faster server startup

MySQL Workbench offers a graphical interface, unlike the CLI which is text-based.

How do you exit the MySQL CLI?

A exit;

B stop;

C close;

D end;

Typing exit; or quit; exits the MySQL CLI.

Which of these is NOT a feature of MySQL Workbench?

A Typing commands in terminal

B Running SQL queries

C Visual database design

D Server administration

Typing commands in terminal is a feature of the CLI, not Workbench.

What does the '-p' option do in the MySQL CLI command?

A Prepares database

B Prints database info

C Prompts for password

D Performs backup

The '-p' option tells MySQL CLI to ask for your password.

Explain how to connect to a MySQL database using the CLI and how to exit it.

Think about the command to start and the command to leave the CLI.

Describe the main differences between MySQL CLI and MySQL Workbench.

Consider how you interact with each tool.