Connect to MySQL via PHP script tunnel

Question

Here's the question, I need to connect to a remote MySQL database from my C# Application, problem is the MySQL instance will block all access to all IP's apart from localhost, this can not be changed as its too much of a security issue.

The question is, is it possible to connect via a tunnel instead to a php script hosted on the server, this would then act as the mysql connection.

Any ideas and suggestions?

So you'd have the PHP script push sql commands to the local mysql server? Sounds like a hack that will create a gaping security hole. Can't you just open up mysql to a specific set of IP's? — Lee Davis
– Lee Davis, Commented Apr 11, 2012 at 11:31
@LeeDavis The issue is the people using the software will be out on site at different clients each day, this would cause more of a security issue than securing a php script — Neo
– Neo, Commented Apr 11, 2012 at 11:50

Community · Accepted Answer · 2017-05-23 10:34:38Z

2

SQLYog (a mysql management GUI utility) already has this php tunnel script with its own custom API, so if you consider writing it yourself, would be nice to have cross-support. See Is there any good universal PHP MySQL HTTP tunnel?

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Apr 11, 2012 at 11:49

Artjom Kurapov

6,1554 gold badges34 silver badges43 bronze badges

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

2 Comments

Neo Over a year ago

hmmm if I'm reading that right they pass xml to the php script to run the commands and return xml. While that would work I could create my own API system instead, the idea is to open up mysql to raw commands without hooking into port 3306.

Artjom Kurapov Over a year ago

Well since mysql uses TCP (or sockets or pipes) as its protocol, while php is called through a HTTP web server.. you would need to run php as a daemon and thus still require some port to maintain TCP. Which is pointless.. Same questions were closed previously too.. stackoverflow.com/questions/5539793/tunnelling-tcp-over-http

scibuff · Accepted Answer · 2012-04-11 11:31:27Z

0

yes, just create a simple PHP script that will give you the desired output and use http request from the c# application to that php script to get the data - basically, you'll be building a very simple REST API (with authentication)

p.s. I don't see how that would be more secure than SSH tunnelling

answered Apr 11, 2012 at 11:31

scibuff

13.8k2 gold badges30 silver badges34 bronze badges

Comments

Neo · Accepted Answer · 2012-04-27 15:20:17Z

0

I ended up with going for an SSH port tunnel and achieving what I needed to do that way.

answered Apr 27, 2012 at 15:20

Neo

2,4054 gold badges42 silver badges73 bronze badges

Collectives™ on Stack Overflow

Connect to MySQL via PHP script tunnel

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related