How to implement basic security on your MySQL instance

Overview

The first things you should do when installing MySQL is to secure your installation.

Secure your MySQL installation

Here are few step to perform basic security on your MySQL instance

• Once you install your MySQL you should run mysql_secure_installation
• You should change the default port by ediiting my.cnf and change the port number. Default port number is 3306. to change the port number in MySQL, add port=new_port_number in the [mysqld] section in /etc/my.cnf then restart you MySQL after the change.
• Once this is done you can start your mysql. then you should change the root password 
• mysqladmin -u root password your_new_password