Database access - keeping it secure

Category: Databases

Star1234556
Asked:
2012-05-13 2:30 pm EST

Hits: 749
I have a form that I want to store the input in a SQL database. How do I keep the database access secure? Do other web applications code the database signon and password in the program?

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

BradM
Staff
5,399 Points
2012-05-14 9:53 am EST
Hi Star1234556,

How do I keep the database access secure?

Keeping database access secure involves two things primarily:

1. Choosing a strong password. Ensure your database password is at least 8 characters and contains a combination of uppercase / lowercase / numbers / and special characters.

2. Ensuring your PHP code has built in checks for common hack techniques, such as code injection.

Please keep in mind that database security (and security in general) is a huge concept. If companies like Sony (playstation 3) YouTube can be hacked, it's a possibility than anyone can be hacked.

Do other web applications code the database signon and password in the program?

Yes, most php applications will store the database username and password either in the php code directly or in an include file, such as include.ini. If you're looking for a specific example, we actually have an online tutorial for using PHP to interact with a MySQL database.

I hope this helps point you in the right direction. Feel free to post any follow up questions in the comments at the bottom of this page.

Thanks!
- Brad

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!