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 an ORM, how does it work, and how should I use one? [closed]
  59. What is the difference between an ORM and an ODM?
  60. What is this JavaScript “require”?
  61. Rename a table in MySQL
  62. How should I tackle –secure-file-priv in MySQL?
  63. What is this JavaScript “require”?
  64. What is “Advanced” SQL?
  65. What’s the difference between identifying and non-identifying relationships?
  66. What are the differences between B trees and B+ trees?
  67. MySQL SELECT increment counter
  68. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  69. Example of a strong and weak entity types
  70. Oracle SQL query for Date format
  71. phpMyAdmin – Error > Incorrect format parameter?
  72. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  73. Difference between partition key, composite key and clustering key in Cassandra?
  74. How SID is different from Service name in Oracle tnsnames.ora
  75. What is a relation in database terminology?
  76. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  77. Database vs File system storage
  78. Can I have multiple primary keys in a single table?
  79. Exclude Statement in SQL
  80. How do you query for “is not null” in Mongo?
  81. What is a file based database?
  82. Is it fine to have foreign key as primary key?
  83. Storing Images in DB – Yea or Nay?
  84. Using wpdb to connect to a separate database
  85. how to Optimize WordPress database for 10 million post? [duplicate]
  86. MySQL Database User: Which Privileges are needed?
  87. Why is my database import losing text widget data?
  88. Database synchronization between dev/staging and production
  89. Keeping WP database synced across multiple developers using git
  90. WPDB Insert or if exists Update
  91. Multiple developers / editors working on a site in progress
  92. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  93. get_results using wpdb
  94. Will it break my site if I delete all transient records in wp_options table?
  95. Checking if Database Table exists
  96. Why WordPress choose data serialization over json_encode?
  97. What’s the simplest way to backup my WordPress database?
  98. WordPress (MyISAM) database is slow, should I switch to InnoDB?
  99. $wpdb won’t insert NULL into table column
  100. Relaunch 4.2 utf8mb4 database upgrade
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)