CompTIA DataSys+ (DS0-001)Database DeploymentEasy
A database administrator is deploying a new MySQL server on a Linux host. After the initial installation, the administrator needs to secure the installation by removing anonymous users, disallowing remote root login, and removing the test database. Which command-line utility is specifically designed for these post-installation security tasks?
- Amysql_secure_installation
- Bmysql_upgrade
- Cmysqldump
- Dmysqladmin
Show answer & explanationAnswer & explanation
Correct answer: A. mysql_secure_installation
The `mysql_secure_installation` utility is a standard script provided with MySQL to perform essential security hardening steps immediately after installation, such as setting the root password, removing anonymous users, disallowing remote root logins, and removing the test database.
Why the other options are wrong
- B. mysql_upgrade is used to check and upgrade MySQL tables after a server upgrade.
- C. mysqldump is used for logical backups of MySQL databases.
- D. mysqladmin is for administrative operations like checking status, creating/dropping databases, but not for initial security hardening.
MySQL Secure Installation
A post-installation script for MySQL servers that guides users through essential security hardening steps to make the database more secure.
- Sets root password.
- Removes anonymous users.
- Disallows remote root login.
- Removes test database and associated privileges.
Memory trick: Secure your MySQL, don't leave it open!