Question

What is the best practice do DBA sercurity in MySQL?

Answer 1

Best Practices for DBA security are as follows:

1)It is necessary to make your server physically secure.Jence,make sure that you have your server located remotely.Assign minimum priveldeges for command runing on same machine where server exists.We can install antivirus,also provide firewall utility,disable useless services etc.

2)there are lot of possibility that attack will happen from outside network hence try to make your access to server restricted from outside client.For this you can use firewall,iptables etc. which restrict access through ports of system.

3)It is neccessary to change default root name given by MySql which is root.Also you should keep frequently change passowrd of system so it become difficuilt for hacker to hack it.

4)MySql provides Test database which is used for testing purpose by unknown users.It can be used by hackers so it is better to remove it.

5)We should frequently check different account and their password.If we find any account suspecious we should remove it.Such as account with blank password etc.

6)It is neccessary to remove history of system while creating database because it may conatin username and password.

7)It is neccessary to keep your database updated using different patches provided by system.