Installing and hardening MySQL server with mysql_secure_installation

In this recipe we will learn how to install and harden MySQL server by using the mysql_secure_installation script that implements the necessary recommendations that will serve to improve the security of your server.

Supporting over 70 collations, more than 30 character sets, multiple storage engines and deployment in virtualized environment; MySQL is a mission-critical database server that is used by production servers all over the world. It is capable of hosting a vast number of individual databases and it can provide support for various roles across your entire network. MySQL server has become synonymous with the World Wide Web(WWW), it is used by desktop software, extends local services and is one of the world's most popular relational database systems. The purpose of this recipe is to show you how to download, install, and lockdown this powerful database server.

Getting ready

To complete this recipe you will require a...