Outside database connection - (securely) - MySQL/PHP

Question

I'm developing an online application that will have many outside users. As for now my connection method is to host a centralized database for all users, while they connect from their own server files.

Method:
PHP Connection File (hosted on their server; file provided by me) >> Connects to my MySQL Database

Now obviously I need to provide my database user and pw info, but I know that questions security.

So to my point, how would I provide database access to outside users(different servers) without giving up security.

Or if someone has a better method I'd love to hear it. Thanks!

huysentruitw · Accepted Answer · 2012-07-13 18:04:05Z

3

Create an API in php, sort of webservice with an interface that you define and host this API on your server.

Each user (script that runs on users server and uses your API) needs a personal API key or access code they need to register to the webservice.

Take a look at well known API's like Google maps or something similar. Oh even stackoverflow has one

edited Jul 13, 2012 at 18:04

answered Jul 13, 2012 at 17:57

huysentruitw

28.2k10 gold badges95 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

andrewsi Over a year ago

This. If you create your own API, you can control exactly what parts of the database users have access to, and their permission levels.

Evan Drury · Accepted Answer · 2012-07-13 18:00:38Z

-2

Create a signup form for users and store their own UserID and Password in a table on your site. Then create a PHP interface for them to upload their files. That way, you need only validate thier own UserID and Password through a HTML/PHP form to allow them to sign in, and your MySQL creds stay safely hidden.

answered Jul 13, 2012 at 18:00

Evan Drury

731 silver badge7 bronze badges

1 Comment

0953109357 Over a year ago

My original idea was to allow them to upload their files to our server, but have decided it would be better for their files to be elsewhere while we allowed them to pull data from one location.

Collectives™ on Stack Overflow

Outside database connection - (securely) - MySQL/PHP

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related