MySQL installation and setup - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding MySQL Installation Components

Which of the following components is NOT typically installed as part of a standard MySQL server installation?

A MySQL Server daemon

B MySQL Router for load balancing

C MySQL Workbench GUI tool

D MySQL Client command-line tool

💡 Hint

Think about what is essential for running MySQL versus optional tools.

MySQL Router is an optional component used for routing and load balancing, not part of the core server installation.

❓ query_result

intermediate

Checking MySQL Server Version After Installation

After installing MySQL, you run the command mysql --version. What output should you expect if the installation was successful?

A mysql Ver 8.0.32 for Linux on x86_64 (MySQL Community Server - GPL)

B bash: mysql: command not found

C ERROR 1045 (28000): Access denied for user 'root'@'localhost'

D Welcome to the MySQL monitor. Commands end with ; or \g.

💡 Hint

The command mysql --version shows version info, not interactive prompt or errors.

The mysql --version command outputs the installed MySQL client version and platform details.

📝 Syntax

advanced

Identifying Correct MySQL Service Start Command

Which command correctly starts the MySQL server service on a Linux system using systemd?

A sudo systemctl start mysql

B sudo service mysql start

C sudo systemctl start mysqld

D sudo mysql start

💡 Hint

The service name for MySQL in systemd is usually 'mysql', not 'mysqld'.

On most Linux distributions using systemd, the MySQL service is named 'mysql', so sudo systemctl start mysql is correct.

🔧 Debug

advanced

Troubleshooting MySQL Access Denied Error

After installing MySQL, you try to log in with mysql -u root -p but get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
What is the most likely cause?

A MySQL server is not running

B The MySQL data directory is missing

C The root user password was not set or is incorrect

D The MySQL client is not installed

💡 Hint

Access denied errors usually relate to user credentials or permissions.

This error means the password provided for root is wrong or root has no password set yet.

❓ optimization

expert

Optimizing MySQL Installation for Minimal Disk Usage

You want to install MySQL on a system with very limited disk space. Which installation option will minimize disk usage while still allowing basic database operations?

A Install MySQL Server and MySQL Workbench GUI tool

B Install MySQL Server with all default components including sample databases and documentation

C Install MySQL Router and MySQL Shell only

D Install only the MySQL Server core binaries and client tools, excluding sample databases and documentation

💡 Hint

Think about what is essential for running the server versus optional extras.

Installing only the core server and client tools without extras reduces disk usage significantly.

Practice

1. What is the first step to start using MySQL on your computer?

easy

A. Connect to a remote server without setup

B. Download and install the MySQL software

C. Create tables without installing anything

D. Write SQL queries immediately

Solution

1. Step 1: Understand the installation process

   Before using MySQL, you must have the software installed on your computer or server.

2. Step 2: Identify the first action

   The first action is to download and install the MySQL software from the official website or trusted source.

3. Final Answer:

   Download and install the MySQL software -> Option B

4. Quick Check:

   Installation starts with downloading software [OK]

Hint: Always download and install before using MySQL [OK]

Common Mistakes:

• Trying to run queries before installation
• Assuming tables exist without setup
• Connecting without a server running

2. Which command is used to start the MySQL server after installation on a Linux system?

easy

A. run mysql

B. mysql start

C. start mysql

D. service mysql start

Solution

1. Step 1: Identify the correct service command

   On Linux, services are managed with the service command or systemctl. To start MySQL, you use service mysql start.

2. Step 2: Check other options

   Commands like mysql start, start mysql, or run mysql are not valid Linux commands to start the MySQL server.

3. Final Answer:

   service mysql start -> Option D

4. Quick Check:

   Linux service start command = service mysql start [OK]

Hint: Use 'service mysql start' to launch MySQL server on Linux [OK]

Common Mistakes:

• Typing 'mysql start' which is invalid
• Using Windows commands on Linux
• Forgetting to start the server before connecting

3. After installing MySQL and starting the server, which command connects you to the MySQL shell as root user?

medium

A. mysql -u root -p

B. connect root mysql

C. start mysql root

D. mysql root login

Solution

1. Step 1: Recognize the MySQL client connection command

   The command to connect to MySQL shell is mysql with options for user and password prompt: mysql -u root -p.

2. Step 2: Validate other options

   Commands like connect root mysql, start mysql root, and mysql root login are not valid MySQL client commands.

3. Final Answer:

   mysql -u root -p -> Option A

4. Quick Check:

   Connect with user and prompt = mysql -u root -p [OK]

Hint: Use 'mysql -u root -p' to connect as root user [OK]

Common Mistakes:

• Omitting '-u' or '-p' flags
• Using incorrect command order
• Trying to connect without server running

4. You installed MySQL but get an error when trying to start the server: 'command not found'. What is the likely cause?

medium

A. The database is empty

B. You forgot to write SQL queries

C. MySQL server is not installed or PATH is not set

D. You are connected as root user

Solution

1. Step 1: Analyze the error message

   'command not found' means the system cannot find the MySQL server command, usually because it is not installed or the PATH environment variable does not include MySQL binaries.

2. Step 2: Check other options

   Forgetting to write queries, empty database, or user connection status do not cause 'command not found' errors.

3. Final Answer:

   MySQL server is not installed or PATH is not set -> Option C

4. Quick Check:

   'command not found' = missing install or PATH [OK]

Hint: Check installation and PATH if 'command not found' appears [OK]

Common Mistakes:

• Assuming error means SQL syntax problem
• Ignoring PATH environment variable
• Trying to connect without server installed

5. You want to install MySQL on a Windows machine and ensure it starts automatically after reboot. Which step should you include during setup?

hard

A. Select the option to install MySQL as a Windows service

B. Only download the installer without running it

C. Manually start MySQL each time after reboot

D. Disable all firewall settings

Solution

1. Step 1: Understand Windows service setup

   Installing MySQL as a Windows service allows it to start automatically when the computer boots.

2. Step 2: Evaluate other options

   Downloading without running does not install MySQL; manual start is inconvenient; disabling firewall is unsafe and unrelated to auto-start.

3. Final Answer:

   Select the option to install MySQL as a Windows service -> Option A

4. Quick Check:

   Windows service = auto-start MySQL [OK]

Hint: Choose Windows service install for auto-start [OK]

Common Mistakes:

• Skipping service installation option
• Thinking firewall disables auto-start
• Not running installer after download