MySQL security and speed

MySQL security and speed

hey everyone!

i already made a good guestbook and login system for my friends site and i practice a lot with free php scripts to make myself better coding php. its great! now im getting into mysql because its pretty cool what you can do with it plus its a whole system ready for you and you dont have to write your own flatfile stuff.

but how secure is mysql? can the databases be completely hidden and locked and not be taken easily? and its true that its a extreme increase in speed from reading and writing text files on local folders? i hope you understand my questions and you dont mind a newbie asking them. thanks!

i think ill admit my questions were a bit broad and have lots of factors btw. but looking forward to the answers if you dont mind as im new and i need to know if mysql is secure and fast compared to what im used to doing.

As far as I know MySQL is secure as long as nobody hacks your hosting account and you have secure code. If you have script where a user can insert information into a database from a form you must ensure the user cannot inject SQL queries through it. Look at this for a bit of info http://www.ilovejackdaniels.com/php/writing-secure-php/2/. Probably not the best article but its not too bad.

As for the speed increase, I'm not sure.

thanks for the good info on security :) i read all of the article on the link and i think im getting an idea of things.

Yes Mysql is quite secure. I have neer had problem in them but sometimes Phpmyadmin tends to use lots of system resources thats somthing bad about it

Same here i found phpmyadmin uses to many system resources so yes that is something bad about it and that needs clearing up, but MySQL i have never had a problem with really as its as secure as my computer lol :).

the biggest problem is that sql is never secure. there is no 100% surity that our sql will b secure and safe from hacking . there got to b a system to make that sure.

I've been using MySQL for years now, and I've never had a problem with security (yet). A lot of it has to do with making sure you check all incoming data to be sure someone isn't trying to send the wrong sort of thing. As long as you take care of that, you're pretty much safe, as far as I know.