Connect to a MySQL server over SSH in PHP

by

I would use the autossh tool to create a persistent ssh tunnel to your mysql database. Then all you have to do in your PHP code is point it to localhost.

You can test this (without automatic restart) by doing:

ssh -L 3306:localhost:3306 [email protected]

Setup a ssh key so that you don’t need to use passwords, and tweak the .ssh/authorized_keys file on the mysql system to only allow it to be used for port forwarding.

For more info on ssh tricks see Brian Hatch’s excellent series on SSH and port forwarding.

More Related Contents:

  1. Connect to a MySQL server over SSH in PHP
  2. How to avoid to display this error in PHP?
  3. Disappears \ from db value [closed]
  4. What to put in database columns when creating registration/login system? (xampp)
  5. How to properly set up a PDO connection
  6. Query with multiple values in a column
  7. Preserve Line Breaks From TextArea
  8. Search with comma-separated value mysql
  9. How to do this in Laravel, subquery where in
  10. How can I loop through a MySQL result set more than once using the mysql_* functions?
  11. PHP MySQLI Prevent SQL Injection [duplicate]
  12. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  13. WAMP Cannot access on local network 403 Forbidden
  14. How do I give each registered user their own url using PHP?
  15. MySQL “NOT IN” query 3 tables
  16. Access denied for user ‘root’@’localhost’ with PHPMyAdmin
  17. LOAD DATA LOCAL INFILE forbidden in… PHP
  18. How get all values in a column using PHP?
  19. Warning: mysql_query(): 3 is not a valid MySQL-Link resource
  20. Why does this return Resource id #2? [duplicate]
  21. In PHP with PDO, how to check the final SQL parametrized query? [duplicate]
  22. Dynamically create PHP object based on string
  23. Insert current date in datetime format mySQL
  24. How to build unlimited level of menu through PHP and mysql
  25. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  26. select within 20 kilometers based on latitude/longitude
  27. JSON vs. Serialized Array in database [closed]
  28. Pass PHP variable to bootstrap modal
  29. php (fuzzy) search matching
  30. SPARQL query to get all parent of a node

Leave a Comment