SECURITY IN MYSQL

Hello the IT knowledge (science) lovers.. you are on my blog at “We Are Knowledge”.. In here you will getting many IT knowledge from IT knowledge based desktop programming until web programming. You can take it FREE.. so you mustre ad my article in order to getting this IT knowledge..

Now, I want giving you tutorial about “MYSQL” and discuss about “SECURITY IN MYSQL”. You will know previous ?? or you will know that ?? let’s do read this article. Have fun friends to read ..

Security in the program that we make is very necessary, because if we make the program we have or do not have security, then we will easily enter the program by others without our knowledge, and take that information can even damage the contents of the program or that program.

The following tips - tips from me in order to maintain security on your MYSQL.

1. Try not to let you not provide access to all users (such as update, insert, delete) except for the root user. because if you let them know that access, then others can freely enter your data (MYSQL)

2. You must understand the command or query MYSQL, namely: GRANT and REVOKE. This query is used to set permissions on your MYSQL.

3. If you make the MYSQL password, do not use plain text form, try using PASSWORD () or MD5, because if you use this content you will not know the password.

4. In making your password should combine letters and numbers, because then your password is difficult to know other people, but you have to remember if the tone forget, your data will not be open again

5. Use a firewall to prevent intrusion, because with this, it can reduce the percentage of intrusion by strangers

6. And my last point is, be - careful with the internet, because if you use this tool to transfer the data, your data can be known by the hijackers.

Ok.. just it…

Ihope you understand…

See you laters..