How can you protect your MySQL server against Denial of Service attacks?

In a Denial of Service attack, a malicious user may load the server with so many unwanted requests that the system becomes very slow and almost unusable to most of the other genuine users.

  • We can use following techniques to protect our MySQL server against any Denial of Service attacks:
  • We should modify dynamic URLs with %22 (“), %23 (#) etc.
  • We should modify data type in dynamic URLs from number to character format.
  • We should check the size of data before passing it to MySQL. If there is larger amount of data than the average size, it should raise red flag.
  • We should use different users for application connectivity to database than the administrative user.
  • We can also enable strict sql mode to enable system to be more restrictive of the values it accepts..
Read the full book at www.amazon.com
Posted in MySQL, MySQL Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *

*