Allowing clients to connect to my database from their different sites without seeing the db connection parameters
I want my clients (reseller clients) to be able to connect to my database (mysql) from their different sites without being able to see the fi开发者_运维知识库le that has teh db connection parameters using PHP.
Please how can I achieve this?
By using tunneling. You need to create a script that connects to MySQL and exposes MySQL PHP API to the requesting party. After that your resellers use that script to talk to MySQL. That indicates that the tunneling script itself should have some sort of password protection so you don't get anyone using your MySQL.
This question will tell you how to encrypt the connection string.
And this one tells you how to connect securely.
精彩评论