Secure Mysql Server in Redhat/CentOs 6/7 Version

views Security of Mysql server is most important in production environment for a big companies and small enterprises.  You should not allow remote login on the Database server from outside the network.

see url There are few points to keep in mind to secure the Mysql Server from an attack

  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 user to a particular database access if needed ,

purchase generic cytotec online Now Let’s secure Our Mysql Server ,

source url This is a command to secure Mysql Server

binäre optionen startguthaben ohne einzahlung Mysql_secure_installation

priere pour rencontrer le grand amour

go here 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 remove anonymous user

go Now disallow remote login

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

naprosyn 750 mg kullananlar

para que sirve el diclofenac potassium 50 mg Now login to Mysql Server and checked whether test database removed or not.

mysql -u root -p

Well Now your Mysql server is secure.

You’re done



Please enter your comment!
Please enter your name here