InMotion Hosting Support Center

Database access - keeping it secure

Category: Databases

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

Hits: 880
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
5,399 Points
2012-05-14 9:53 am EST
Hi Star1234556,

<strong>How do I keep the database access secure?</strong>

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 <a href='http://en.wikipedia.org/wiki/Code_injection' target='_blank'>code injection</a>.

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.

<strong>Do other web applications code the database signon and password in the program?</strong>

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 <a href='http://www.inmotionhosting.com/support/edu/website-design/using-php-and-mysql' target='_blank'>using PHP to interact with a MySQL database</a>.

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?

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!