Installation for MySQL DBAs
MySQL installation is the process of getting a working MySQL 8.4 server onto a machine, either from packages, binaries or a container, and later upgrading it safely. It is the first step of administration and also includes running the mysql client for basic SQL.
Stage: Setup · Part of the MySQL DBA roadmap · Last reviewed 19 November 2026
What to learn in Installation
- Install MySQL Server from a package repository and start it as a service
- Run mysql_secure_installation style hardening and set the root account password
- Connect with the mysql client and create a database, table and rows
- Plan an in-place upgrade and check for removed features beforehand
- Locate the data directory, error log and my.cnf on a new install
Installation interview questions
What is the difference between an in-place and a logical MySQL upgrade?
An in-place upgrade replaces the binaries and lets the new server start on the existing data directory, which is fast. A logical upgrade dumps data with mysqldump or similar and reloads it into a new server, which is slower but cleaner and easier to roll back.
Where does MySQL read its configuration from?
MySQL reads option files such as /etc/my.cnf, /etc/mysql/my.cnf and a user's ~/.my.cnf, in a defined order, with later files overriding earlier ones. Command line options override all of them. Running mysqld --verbose --help shows the files and defaults used.
Where Installation fits in the MySQL DBA roadmap
Installation belongs to the Setup stage (beginner level), which takes about 33 hours. Install and learn the basics.
Other units in this stage
Back to the full MySQL DBA roadmap