Connect to a remote database for wordpress in my own hosting server

For security issues, Hostgator requires more parameters – like port, etc. – in wp-config.php to connect to a remote – non-localhost – mysql server.

Read http://support.hostgator.com/articles/cpanel/how-to-connect-to-the-mysql-database-remotely

Related Posts:

  1. Problem migrating to localhost
  2. How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
  3. Cloned site not connecting to database – MAMP
  4. Can I connect WordPress website with an external database?
  5. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  6. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  7. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  8. Please explain how WordPress works with MySQL character set and collation at a low level
  9. Connect to database using wordpress wp-config file
  10. Connect to remote database using Localhost install
  11. Best way to move live site local
  12. Accessing two databases
  13. Custom DB_COLLATE (collation) value not working on fresh install?
  14. Connect to live db whilst working locally
  15. No wp-config.php file on local install of wordpress – site still displays
  16. Why can’t I swap a DB in a WP install? [closed]
  17. Can I have multiple database users within WordPress?
  18. Error establishing a database connection on Installation
  19. Import live site to local setup without access to live site
  20. Moving WP from local server to live, error establishing a db connection
  21. Moving online website to MAMP or dumb idea?
  22. Moving minor updates between local and live sites – just database?
  23. Difficulty importing my live site to local
  24. Switching Databases in LocalHost
  25. Localhost to Staging to Development Dynamic WP-CONFIG
  26. How to share plugin created database tables between two WordPress sites
  27. Is my way to change WordPress server is correct?
  28. how to encyrpt DB_PASSWORD in wp-config
  29. Design problems when exporting remote database for local development
  30. How to transfer from localHost to live but use the already existing database on the server?
  31. Installing local to live WP into subdirectory
  32. Database migration issues – Error #1046 No database selected
  33. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  34. Cloning blog to localhost via WAMP
  35. Getting WordPress to work inside a rails 3 application
  36. Can two domains use the same database?
  37. WordPress keeps redirecting to localhost
  38. Recovery – Restore Database after moving folder location locally
  39. Duplicate database to roll back theme & content changes
  40. Search and Replace in Windows XAMPP site
  41. Confused over wp-config.php and ‘database user + database password + name’
  42. Locally installing wordpress. Database problem
  43. execute custom function on database connection error
  44. Does WordPress Support Using Named Pipes on the Windows Operating System?
  45. I have include wp-config, should I add global $wpdb also?
  46. Can’t Install WordPress (local) Failed to open file wp-includes/wp-db.php
  47. Issue “Error establishing a database connection” problem.
  48. Local Content different from Remote Content
  49. How can I work on a database along side a client?
  50. Restoring .sql backup results in “Error establishing a database connection”
  51. /var/run/mysqld/mysqld.sock
  52. DB access blocked when initializing WP externally
  53. How to use remote db tables in current config? [duplicate]
  54. Multiple Address In WP-Option Value
  55. ERROR: “Table Prefix” must not be empty
  56. Theme Options – localhost to new url
  57. wp-config was suddenly updated
  58. What is this JavaScript “require”?
  59. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  60. get_results using wpdb
  61. wpdb->insert multiple record at once
  62. How to migrate a HTTPS WordPress installation to localhost?
  63. How to monitor server for error establishing a database connection
  64. remove missing image attachments
  65. Transient RSS feeds in wp_options not removed automatically?
  66. How to ensure data consistency in WordPress
  67. Database location in WordPress
  68. Bad Request (Invalid Hostname) on working server, database problem
  69. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  70. Change SQL get_results to search for posts with custom term in custom taxonomy
  71. How to diagnose and keep in check encoding issues?
  72. Add search Value to wp_list_table pagination
  73. I have a table I created, how do I make a form for a user to filter the data?
  74. wp_redirection_404 table has grown to 7GB
  75. Multiple wp_options tables to share content across installs
  76. Connection refused on locahost after importing database?
  77. When to use custom DB tables or add_option?
  78. creating new field on mysql
  79. Does WordPress store the username as a primary key in the database?
  80. Database Update Required – Update from command-line
  81. SQL query to set posts in bulk based on the post content
  82. Automate WordPress website setup with prefilled data
  83. Custom search query by category id
  84. Fetch a single row from a custom table for to a given ID
  85. Database create or redirect
  86. Database structure cheatsheet
  87. WordPress Database – wp_usermeta and the correct number of session_tokens rows
  88. A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
  89. error establishing database connection (WAMP + filezilla)
  90. Is there a way for two deferent themes to consume two different DB on a same WP instance?
  91. How do I update a WordPress wp_postmeta meta_value that contains many options
  92. Auto populate form fields based on serial input or pull listings from other websites?
  93. How to extract some part of WordPress full source code
  94. Error establishing a database connection for some files
  95. Hash user emails in database?
  96. Saving data to database and exporting to excel
  97. Site does not work right, pages not showing up, even for root admin
  98. One information repeated on multiple locations on one site [closed]
  99. Showing Error(TAble already exist)
  100. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]