MySQL 8.0 Database Administrator — Question 63

You wish to protect your MySQL database against SQL injection attacks.
Which method would fail to do this?

Answer options

• A. installing and configuring the Connection Control plugin
• B. avoiding concatenation of SQL statements and user-supplied values in an application
• C. using stored procedures for any database access
• D. using PREPARED STATEMENTS

Correct answer: A

Explanation

The correct answer is A because the Connection Control plugin does not specifically address SQL injection vulnerabilities; it primarily manages user connections. Options B, C, and D are all effective methods to prevent SQL injection by using best practices in handling SQL commands and user inputs.