Jump to content

secure connections to MySQL from PHP


badboy

Recommended Posts

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 !
Link to comment
Share on other sites

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.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.