Quantcast

Forums | MacLife

You are not logged in.

#1 2003-01-07 6:30 pm

Gipetto
Yankee Doodle's noodle
Royal Wombat
From: People! Ahg!!
Registered: 2000-09-24
Posts: 9941
Website

MySQL Security

Okay, I've gotta present the concept of a database driven website to people who know nothing about security.

What I know is the basics, password protected directories, limited access, the fact that the DB is not stored in a public folder, the freinds file.

Is there more I can say that can ease some minds here? If I can, I can move forward faster with this project.

The powers that be are worried that the names and email addresses of clients will be accessable to theives. The names are being gathered as a sign up for an email newsletter.

Thanks

Shawn

Offline

 

#2 2003-01-07 8:02 pm

Scott
Zombie Gorilla
From: Oregon
Registered: 2002-12-07
Posts: 3446
Website

Re: MySQL Security

Okay, I've gotta present the concept of a database driven website to people who know nothing about security.

Make up words and shovel bs with conviction.

j/k.

The information is not publicly accessible is it?  Only from an admin section or local connection?  It's about as secure as it can be really.  (or needs to be rather)  You could go nuts with security, but no reason with that kind of data.

Don't tell them that it is 100% secure (there is no such thing), but a MySql database is has built in security, and whatever additional steps you take to lock it down is all the information they need.   It's a standard way of operating, and it is secure.  Email harvesters use shady methods to get email sometimes, but rarely do the "steal" databases.  They are usually not that savvy. 

Security is your responsibility and you will take all the appropriate steps need to safe-guard the data.

If that fails, just tell them for security reasons, you can't divulge the details of your security procs to anyone.


wink


http://www.greatgamesexperiment.com/images/logo_kit/468x60-Blue.gif

Offline

 

#3 2003-01-08 12:04 am

Gipetto
Yankee Doodle's noodle
Royal Wombat
From: People! Ahg!!
Registered: 2000-09-24
Posts: 9941
Website

Re: MySQL Security

Make up words and shovel bs with conviction.

I may have pushed that one about as far as I can go smile

Thanks for the reply, you've set my thoughts straight as that is what I was thinking.

I've pretty much scoured for every MySQL security article I can find and it was the MySQL manual that actually offered the best info.

So I think I may have enough B/S to make this shine smile

Thanks

Offline

 

#4 2003-01-11 1:33 pm

DH
Member
Registered: 2000-06-10
Posts: 1767
Website

Re: MySQL Security

Make up words and shovel bs with conviction.

I may have pushed that one about as far as I can go smile

Thanks for the reply, you've set my thoughts straight as that is what I was thinking.

I've pretty much scoured for every MySQL security article I can find and it was the MySQL manual that actually offered the best info.

So I think I may have enough B/S to make this shine smile

Thanks

BS is great. wink

I've thought about MySQL security quite a bit, and it seems that in the most obvious places MySQL is very secure.  I imagine the biggest holes are the most traditional ones, like someone making a password something silly (like "password").

I found the MySQL manual, and also some tutorials online to be the biggest help.  I haven't gone through this one yet: http://www.macromedia.com/desdev/mx/dre … 2_php.html but perhaps it can be of help?

Offline

 

#5 2003-01-12 12:05 am

Gipetto
Yankee Doodle's noodle
Royal Wombat
From: People! Ahg!!
Registered: 2000-09-24
Posts: 9941
Website

Re: MySQL Security

I don't use Dreamweaver, but I'll give it a look.

It seems that the manual for mySQL has been the most helpful of what I've found.
And you're right, stupid passwords are definitely a good place to look.
Another good one I found to test for was that well formed (ie: somebody knew what to ask) query's from a search field could result in a return of vital information - ie: somebody could possibly query the user database for names and passwords (or other vital areas for vital info), so lock that up tight!

I also read that it's a good idea to have root open as a last resort and run EVERYTHING from permissions based users. Nobody gets permission to do more than they need to.

Offline

 

Board footer

Powered by PunBB 1.2.6
© Copyright 2002–2005 Rickard Andersson