What are the Security Points we need to keep in mind while using MySQL?

Question

Are there any defined rules that should be considered while writing function definition ?

Answer 1

Following Points should be followed while using MYSQL.
1.Access to the user table should never be given to avoid SQL injection attacks.
2.Privileges such as GRANT and REVOKE must be made use of.
3.SHOW GRANTS can be used to see the list of users who have access
4.Never run the MySQL server as the Unix root user
5.Validation of data and queries should be thoroughly checked.