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..