QuizzesMySQL Security Best Practices — Concept Check
intermediate
mysql

MySQL Security Best Practices — Concept Check

Questions on MySQL Security Best Practices. Grant least-privilege, use SSL/TLS, hash passwords with caching_sha2_password, rename the root account, disable remote root login, and audit access with the audit log plugin.

7 minutes 7 questions Pass at 70%
Time Limit
7 minutes - timer starts when you begin
Change Answers Freely
Revisit and change any answer before submitting
Full Review After Submit
Correct answers and explanations shown for every question
Auto-submit on timeout
Quiz submits automatically when time runs out

Questions in this quiz

7 questions on MySQL Security Best Practices — Concept Check. Work through them here, then start the quiz to answer them and see your score.

  1. 1.A MySQL database administrator notices that the root account can log in from any host. What is the best practice to secure this account?

    • AUse the mysql_native_password plugin for root
    • BSet a weak password for root to simplify access
    • CDisable remote root login and allow only localhost access
    • DGrant root privileges to all application accounts
  2. 2.A developer is setting up a new MySQL user for an application. Which of the following practices should they follow?

    • AUse mysql_native_password for compatibility
    • BGrant all privileges to simplify management
    • CAllow remote root login for convenience
    • DUse caching_sha2_password for authentication
  3. 3.An application requires access to the 'orders' table in the 'shop' database. What is the best way to grant permissions?

    • AGrant ALL PRIVILEGES on shop.orders
    • BGrant SELECT, INSERT, UPDATE, DELETE on shop.orders
    • CGrant SELECT, INSERT on shop.orders
    • DGrant SELECT on shop only
  4. 4.A MySQL server is configured with TLSv1.2 and TLSv1.3. What happens if a client attempts a non-SSL connection?

    • AThe connection is rejected due to require_secure_transport
    • BThe client automatically upgrades to SSL
    • CThe server downgrades to mysql_native_password
    • DThe connection is accepted without encryption
  5. 5.A team wants to audit MySQL login events and DDL changes. Which plugin should they use?

    • AMySQL Enterprise Audit Log Plugin
    • Bmysql_native_password
    • Cgeneral_log
    • Dcaching_sha2_password
  6. 6.Why is it important to replace auto-generated certificates with CA-signed certs in production?

    • AAuto-generated certs are only valid for localhost
    • BCA-signed certs are required for mysql_native_password
    • CAuto-generated certs are less secure and not trusted externally
    • DCA-signed certs are faster to generate
  7. 7.A MySQL user is configured with 'REQUIRE SSL'. What will happen if the connection attempt does not use SSL?

    • AThe connection will proceed with a warning
    • BThe user will be prompted to enable SSL
    • CThe connection will be rejected
    • DThe server will automatically enable SSL