Question

You need to make your MySQL system secure against attackers. What are you not supposed to do?

a) Use strong passwords
b) Regularly update MySQL
c) Disable the firewall
d) Restrict user privileges

Answer 1

To secure a MySQL system, do not disable the firewall, as it is one of the key defenses against unauthorized access. You should instead use strong passwords, regularly update MySQL, and restrict user privileges.

Step-by-step explanation:

To secure a MySQL system against attackers, you should not disable the firewall. The firewall acts as a barrier between your MySQL server and unauthorized access, blocking malicious traffic and attempts to breach your system.

Instead, maintaining strong security practices involves actions such as using strong passwords for all accounts, regularly updating MySQL to apply security patches and bug fixes, and restricting user privileges to the least amount necessary for each role to perform its duties, which limits the potential damage of a compromised account.