Connecting to MySQL via SSH with PHP

Question

Is it possible to connect to a MySQL database, on remote server, via SSH using PHP that is installed on my local computer?

I am a bit confused on this subject. My shared hosting provider suggests I use programs like MySQL Query Browser and Microsoft SQL Server Management Studio Express.

I have done some research on SSH at php.net (as well as other places) but their manual on the subject is not very helpful.

You realize that running queries over a SSH tunnel (AKA VPN connection) will impact the speed that queries are sent to MySQL, and how fast they are returned to the webserver? — OMG Ponies
– OMG Ponies, Commented Jan 25, 2010 at 3:34

Ignacio Vazquez-Abrams · Accepted Answer · 2010-01-25 03:35:18Z

2

Yes. You'll need to set up a SSH tunnel, and connect via TCP/IP.

answered Jan 25, 2010 at 3:35

Ignacio Vazquez-Abrams

804k160 gold badges1.4k silver badges1.4k bronze badges

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

Comments

Matt Dunbar · Accepted Answer · 2010-01-25 03:39:20Z

0

If you are unable to setup a tunnel as mentioned above, you can alternatively execute commands yourself over an open socket. Look into fsockopen.

answered Jan 25, 2010 at 3:39

Matt Dunbar

9503 gold badges11 silver badges21 bronze badges

1 Comment

Ignacio Vazquez-Abrams Over a year ago

If fsockopen() were to work then a direct connection could just be made instead.

Collectives™ on Stack Overflow

Connecting to MySQL via SSH with PHP

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related