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.