Configure WordPress to connect to Mysql DB using SSH tunneling

You should create a ssh tunnel between the 2 serves. Then you can connect from the WP with only the mysql server ip.

ssh -f [email protected] -L 2000:personal-server.com:25 -N

The -f tells ssh to go into the background just before it executes the command.

This is followed by the username and server you are logging into.

The -L 2000:personal-server.com:25 is in the form of -L local-port:host:remote-port.

Finally the -N instructs OpenSSH to not execute a command on the remote system.

via Revsys

Related Posts:

  1. Column count doesn’t match value count at row 1
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL string replace
  4. MySQL Error “Operand should contain 1 column”
  5. How to use MySQL DECIMAL?
  6. Access denied for user ‘root@localhost’ (using password:NO)
  7. Which MySQL data type to use for storing boolean values
  8. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  9. Cannot delete or update a parent row: a foreign key constraint fails
  10. MySQL server startup error ‘The server quit without updating PID file’
  11. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  12. Your password does not satisfy the current policy requirements
  13. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  14. What is the definition of cardinality in SQL
  15. How to restart remote MySQL server running on Ubuntu linux?
  16. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  17. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  18. Duplicating a MySQL table, indices, and data
  19. Selecting data from two different tables without using joins
  20. Difference between VARCHAR and TEXT in MySQL
  21. MySQL: Invalid use of group function
  22. SELECT * FROM multiple tables. MySQL
  23. How can I loop through all rows of a table? (MySQL)
  24. Simple Random Samples from a Sql database
  25. What does SQL clause “GROUP BY 1” mean?
  26. LAST_INSERT_ID() MySQL
  27. SQL select only rows with max value on a column
  28. Trying to perform MINUS operation in MySQL
  29. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  30. mysql count duplicates
  31. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  32. MySQL config file location – redhat linux server
  33. How to change collation of database, table, column?
  34. Create boolean column in MySQL with false as default value?
  35. Is there a naming convention for MySQL?
  36. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  37. MySql – HAVING vs WHERE 
  38. How to stop mysqld
  39. Is merge statement available in MySQL
  40. GROUP_CONCAT comma separator – MySQL
  41. Set page template for all pages?
  42. How to log mysql errors from wordpress core?
  43. Optimize Multiple Taxonomy Term MySQL Query?
  44. WordPress MySQL & PHP Performance
  45. What specific database privileges does WordPress need?
  46. Using source control with WordPress
  47. My WordPress site always displays a cached version of its homepage
  48. wpdb Custom Meta Data with 2 conditions
  49. Updating User Meta with SQL Query
  50. wpdb prepare syntax
  51. How to run this SQL query of wp_terms database
  52. How to bulk delete all WordPress subscribers?
  53. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  54. Rewrite database urls
  55. SQL error #1062 – Duplicate entry ‘1’ for key ‘PRIMARY’ [closed]
  56. Changing Table Prefix for an Existing WordPresss Site
  57. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  58. Migrating from Existing MySQL Setup to WordPress
  59. Connect another DB and fetch records from some tables
  60. How to split the a table in database?
  61. How do I join a $wpdb query with user meta using default value if not exist?
  62. mySQL statment count of post in each category and sub category
  63. Paypal Post IPN handeling nightmare
  64. Is there a page length limit?
  65. WordPress tables and aliases?
  66. What’s the sql for this condition?
  67. Create a form with custom autocomplete address field and CSV import values
  68. WordPress insert query is not working : Showing no Error
  69. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  70. Copy usermeta value where ID matches in the same table
  71. Some Post Content Does Not Show Up In DB Search
  72. How can I write a formal sql query to get data from a custom table
  73. How to insert dash (-) into database using wpdb and new_to_publish hook?
  74. MySQL: How to change url in posts from xxx.com to yyy.org?
  75. WordPress & MySQL , problem with use many array in meta_query
  76. How can I view my site directly from WordPress dashboard?
  77. (WP List Table) How to sort by SKU and Custom Fields?
  78. Word Press and database from another server sync
  79. User set date and time from frontend doesn’t get stored into database
  80. get posts whether meta_key exists or not
  81. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  82. How to bulk delete a certain part of all wordpress posts
  83. When I add metadata, metavalue length is added in to the value in some cases
  84. Changes not being reflected on new server
  85. WordPress Dutch characters encoding problem
  86. update_option returns false in AJAX, how to debug?
  87. WordPress database error Duplicate entry for key ‘slug’
  88. Select latest 2 articles, but only from given category
  89. MySQL – How to combine data from two tables into one?
  90. Stop my loop to register data twice
  91. `#1215 – Cannot add foreign key constraint
  92. How to restore: Database intact but folders deleted
  93. XML RPC post produces immediate revision with odd post_date_gmt
  94. Woocommerce: Grab total revenue of a product over all orders
  95. SQL command to export post_content from wp_posts using phpMyAdmin
  96. SQL Database Lost
  97. Why does the MySQL command line tool ignore the –port parameter?
  98. Postgres equivalent to MySQL’s \G?
  99. How to find source of these strange SQL queries?
  100. How to reduce uncached page generation time?
tech