AWS Lightsail WordPress – connect to database on instance using mysqli

//Params to connect to a database
$dbHost = "*static ip of wordpress site*";

This should be $dbHost = "localhost"; instead, or "127.0.0.1" (or even "::1").

localhost uses a separate virtual network interface that makes sure traffic between services on your Linux VM doesn’t leave the VM In general it’s safer to use localhost rather than other IPs that belong to host interfaces because

  • you’ll avoid any problems with firewalls that might be configured on the host
  • ditto in an AWS environment you’ll avoid any security group / VPC filters, if e.g. you were using the public facing IP as your host rather than the internal IP address on the virtual private cloud which is different
  • mysql logins can be filtered by the hosts they’re allowed to connect from, and if your root user may be restricted to localhost logins at the database level.

Related Posts:

  1. Undefined function mysql_connect()
  2. MySQL column count doesn’t match value count at row 1 [closed]
  3. dbDelta support for FOREIGN KEY
  4. is it possible to run some php code within a wordpress page?
  5. How to correctly submit a search form and display the result in an independent page
  6. Check if post of title already exists
  7. $wpdb->delete column values IN ARRAY()?
  8. Custom SQL query to get List of posts with featured image url
  9. Does WordPress cache get_user_meta() results?
  10. Delete post revisions on post publish
  11. Using Echo in ShortCode – Stuck
  12. Problems migrating WordPress to localhost
  13. error importing localhost export file to server
  14. How to sort results from a custom database table
  15. Update some database fields when post is saved
  16. sql query to put quotes around numbers in img tag
  17. No wp-config.php file on local install of wordpress – site still displays
  18. Use ajax to update_post_meta
  19. What SQL / WordPress queries would need a nonce?
  20. Different database query in function.php using mysqli
  21. Strange wordpress slowness
  22. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  23. Why is variable not working on custom sql query using wpdb?
  24. How can I export posts with featured images, without download them
  25. How to securely provide a $_POST var in WP_Query with PHP 7?
  26. Create WP_Query to search for posts by their categories or their parent/child categories
  27. WSoD being caused by this piece of code
  28. How to display data from custom table in wordpress phpmyadmin
  29. Update results, Before deleting the related category [closed]
  30. Sum the total amount of a specific product purchased per user and display in table
  31. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  32. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  33. Weird 404 URL Problem – domain name being placed at end of urls
  34. database sent to a JSON file
  35. $wpdb->insert() does not Insert record in a table
  36. Help with a $wpdb MySQL Query
  37. How i can obtain all the post meta for a specific post as an array?
  38. multiple where condition in result query
  39. Can’t Query Custom Table Using $wpdb Method
  40. $wpdb returns duplicate posts
  41. Update postmeta after theme switch
  42. Should I use WordPress to skin a database website?
  43. Creating Database Table vs. Adding MetaData to Post & User
  44. WordPress Custom SQL Table with UserID Filter for results
  45. How can I add a new row in a separate database when someone registers via WordPress?
  46. I can’t update my data through $wpdb
  47. How to use mysql LIKE with wpdb?
  48. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  49. WordPress WP_Query without query GET parameters
  50. How to use AJAX in WordPress in MYSQL query?
  51. Use variable in SQL statement
  52. Processing ajax call to php to insert into mysql database
  53. WPDB secure custom form
  54. Query the links Database
  55. WordPress Custom Query: Combining Two Functions
  56. MySQL Query Returns Array () In Shortcode
  57. How to WP_Query posts order by parent title?
  58. Passing in MySQL prepare statement parameter separately throwing error
  59. Database SQL query error
  60. Display Results of SQL Query on WP site
  61. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  62. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  63. Conditional formatting on data fetched from MYSQL
  64. Can I split a huge wp_postmeta table across different databases or servers?
  65. how to get data from two different table from wordpress database
  66. Passing Current User ID into SQL statement
  67. How to optimize and reduce excessive database queries
  68. How to insert multiple rows and columns in database using array
  69. Store GA Client ID in User DB
  70. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  71. Windows Setup: Error establishing a database connection
  72. Need help with format of nested array in MySQL
  73. WP + MySql db / PHP
  74. WAMP SERVER Command Prompt SET PATH=%PATH%
  75. Inserting other fields to existing registration form in a WordPress theme
  76. Advanced WordPress SQL Query
  77. Splitting table data to pages with numbers
  78. How can get all users by current user meta (array)?
  79. Site doesnt work once PHP changed to 7.1
  80. How to detect if a revision was made by woocommerce or wordpress?
  81. WordPress WPDB::insert 13th param is always blank (only if format)
  82. Ajax not updating to database
  83. can’t delete a row from post_meta table
  84. Send data from plugin to external database
  85. MySQL query in WordPress with AJAX
  86. Processing forms with php to wordpress database
  87. directorypress theme error mysql_error() [closed]
  88. How to connect database table to each registered wordpress user.
  89. retrieve wordpress post-meta using php not wordpress functions
  90. Splash pages on a high traffic site
  91. Using the same shortcode to show any table from the database
  92. I am unable to fetch json data from wp_db
  93. Submit cf7 form to cfdb as pdf/BLOB [closed]
  94. Parse error: syntax error, unexpected ‘}’ in C:\xampp\htdocs\admin\products.php on line 148 [closed]
  95. How to send push notification in android using php? [closed]
  96. Getting invalid user ID error when creating a new user with wp_insert_user
  97. Custom form that stores data in mysql database
  98. Putting form result in my database
  99. How can I update a value of a field depending on outside source?
  100. WordPress Query with meta_key and order by another meta_key