Operating a database service requires more than writing queries: you must start the server, connect in the right security context, separate application access, and prove that data can be recovered. This hands-on course introduces that complete administrative path through MariaDB's MySQL-compatible tools.
You will install and harden the server, navigate the SQL shell, create databases and local users, scope privileges, and test access as the delegated account. You will also perform a destructive recovery drill before completing an application migration from a supplied SQL schema and seed-data file.
What You Will Learn
- Install MariaDB, start the
mysqlservice, and verify its running state - Use the interactive hardening utility to remove common insecure defaults
- Connect through the MySQL-compatible CLI, list databases, select context, and exit
- Create local application users and grant privileges to one database only
- Verify effective access by authenticating as the delegated database user
- Export a logical backup with
mysqldump, drop the database, restore it, and query recovered rows - Import a supplied SQL file and validate its tables through application credentials
Who This Course Is For
This intermediate course is for Linux administrators, DevOps learners, developers, and support engineers who need to provision and operate a small MySQL-compatible database service. It is especially useful if you can write basic SQL but have not yet managed the service, users, privilege scope, or logical recovery from the terminal.
Prerequisites: Basic Linux terminal, package-management, service, file-redirection, and sudo skills. Familiarity with simple SQL statements is helpful but not required.
Learning environment: A Debian/Ubuntu-style LabEx Linux terminal using MariaDB Server and the MySQL-compatible mysql and mysqldump command-line tools.
Frequently Asked Questions
Is this course using MySQL or MariaDB?
The lab installs MariaDB Server, whose command-line clients and core SQL administration are MySQL-compatible for the tasks taught here. You will use familiar commands such as mysql, CREATE DATABASE, CREATE USER, GRANT, and mysqldump.
How advanced is the SQL coverage?
The focus is database operations rather than query development. You list and select databases, create accounts, grant scoped access, import an existing schema, list tables, and inspect prepared rows; joins, indexes, transactions, and schema design are not taught.
Does the backup exercise prove a complete server recovery?
No. It tests a logical backup of one prepared database. Because the dump omits database creation by default in this exercise, you first recreate app_db, import backup.sql, and verify the original Alice, Bob, and Charlie rows. It does not cover physical backups or full-server disaster recovery.
