Jump to content


Photo

secure connections to MySQL from PHP


  • Please log in to reply
1 reply to this topic

#1 badboy

badboy
  • Members
  • Pip
  • Newbie
  • 3 posts

Posted 10 April 2006 - 07:15 PM

Tried to post this on the PHP/MySQL forum but it was not accepting new posts.

Am trying to figure out the optimal secure configuration and performance for PHP MySQL server connections.

Is it more secure to have the PHP applications running on one hardened server and the MySQl on another hardened server ? rather than running all within the same box.

If I run two seperate boxes, what would be the best way to connect to the SQL
server ?

Appreciate all input on this subject.

Thanks !

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 10 April 2006 - 09:01 PM

I'm not sure whether I would say they would be more "secure"... at some level, both boxes should have the same security settings to prevent unauthorized access, intrusions, DoS attacks, etc. There are definitely many MySQL and PHP settings that promote security... too many to list, but if you have specific questions, feel free to ask.

The one advantage you do get from separate these components is that a web server has very different requirements than a database server (think RAM, CPU, HD space, etc.). If it's all on one box, you have to compromise.

Hope that helps.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users