Secure MySQL Database Server

How To Secure MySQL installation database server is most important in the production environment for big companies and small enterprises.  You should not allow remote login on the Database server from outside the network. We can secure and do security tests for the MySQL server in Linux.

The security of the database is important on the server. If you’re using the MySQL server as a database for your application, you can follow the below settings to secure it.

You can also make a connection with https on MySQL server that’s a different process that is not covered here.

There are few points to keep in mind to secure the MySQL Server from an attack.

Check Out: Solve Mysql “Can’t connect to local MySQL server through socket “

  1. Disallow the remote login from outside the network
  2. Remove default test database from the server
  3. Make strong password including Uppercase, lowercase, special character and keep minimum 10 digit length
  4. Remove anonymous login on the server
  5. Only allow the user to particular database access if needed,

How To Secure MySQL Database Server:

Now Let’s start securing Our MySQL Server,

mysql_secure_installation

mysql secure linux

Check Out: Installation of MySQL Workbench 8.0.16 On Ubuntu

When you will run this command it will ask you to set the password policy just press on Yes. Next, it will come to ask you to change the root password press enter and put the root password for MySQL Server.

Now we need to remove anonymous users.

mysql secure installation

We have to disallow remote login.

mysql secure installation

Now remove the test database from the server and press Yes to reload the privileges table row.

Check Out: How To Check Users In Mysql Database Server In Linux

mysql security test

You have to log in to MySQL Server and checked whether the test database removed or not.

mysql -u root -p

Well, Now your MySQL server is secure.

YouTube Link: Secure Mysql

You’re done mysql secure linux security test installation

LEAVE A REPLY

Please enter your comment!
Please enter your name here