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. Fatal error: Call to undefined function mysql_connect()
  4. the_date() not working
  5. How to return number of found rows from SELECT query
  6. Check if post of title already exists
  7. $wpdb->delete column values IN ARRAY()?
  8. How to make WordPress plugin check for database changes and then do something?
  9. Custom SQL query to get List of posts with featured image url
  10. Delete post revisions on post publish
  11. Problems migrating WordPress to localhost
  12. error importing localhost export file to server
  13. How to sort results from a custom database table
  14. Update some database fields when post is saved
  15. Successful or Error Message after running mysql code in functions.php
  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. PHP/MySQL issues when running WP on EC2 cloud [closed]
  20. WordPress get pagination on wpdb get_results
  21. How to create another version of my site based on the same database
  22. Strange wordpress slowness
  23. Looking for most performant way to execute several similar WP queries within shortcodes
  24. Setting All Drafts to ‘exclude-from-catalog’ in WooCommerce
  25. Stumped on migration
  26. PHP code inside shortcodes
  27. Show MySQL errors that occur when I excute $wpdb->insert()
  28. Is XAMPP faster than running LAMP in WSL on Windows 10? [closed]
  29. WordPress Site Running Extremely Slow on Dedicated Server
  30. Get updated query results on page after insert in database
  31. WSoD being caused by this piece of code
  32. WordPress not reflecting changed of the database
  33. How can I fix WordPress installation errors?
  34. How to display data from custom table in wordpress phpmyadmin
  35. How to split links generated into an xml sitemap to avoid exceeding 30 sec maximum execution time?
  36. Hacked WordPress website /Homepage redirect [closed]
  37. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  38. Replacing mysql_escape_string in a custom plugin when moving to PHP7
  39. Refresh table data with Ajax
  40. Database query works fine outside WordPress
  41. Large Woocommerce Site (83,000 items), What Can I Do? [closed]
  42. Help with a $wpdb MySQL Query
  43. How i can obtain all the post meta for a specific post as an array?
  44. Can’t Query Custom Table Using $wpdb Method
  45. $wpdb returns duplicate posts
  46. Update postmeta after theme switch
  47. Mixing variables into an array when inserting values
  48. Should I use WordPress to skin a database website?
  49. Creating Database Table vs. Adding MetaData to Post & User
  50. WordPress Custom SQL Table with UserID Filter for results
  51. How can I add a new row in a separate database when someone registers via WordPress?
  52. How to use mysql LIKE with wpdb?
  53. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  54. WordPress WP_Query without query GET parameters
  55. How to use AJAX in WordPress in MYSQL query?
  56. Use variable in SQL statement
  57. Processing ajax call to php to insert into mysql database
  58. WPDB secure custom form
  59. Query the links Database
  60. WordPress Custom Query: Combining Two Functions
  61. MySQL Query Returns Array () In Shortcode
  62. Passing in MySQL prepare statement parameter separately throwing error
  63. Convert a column of a table containing an Array as response in HTML
  64. Database SQL query error
  65. Display Results of SQL Query on WP site
  66. MYSQL TIMESTAMP when adding DATE_FORMAT then the output is blank, PHP conflict?
  67. Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”
  68. how to get data from two different table from wordpress database
  69. Passing Current User ID into SQL statement
  70. How to optimize and reduce excessive database queries
  71. How to insert multiple rows and columns in database using array
  72. Store GA Client ID in User DB
  73. WordPress mysql deos not work with php7
  74. PHP 7.2.18 | Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  75. Windows Setup: Error establishing a database connection
  76. Need help with format of nested array in MySQL
  77. WAMP SERVER Command Prompt SET PATH=%PATH%
  78. Inserting other fields to existing registration form in a WordPress theme
  79. Advanced WordPress SQL Query
  80. Splitting table data to pages with numbers
  81. How can get all users by current user meta (array)?
  82. Site doesnt work once PHP changed to 7.1
  83. Add two or multiple functions in WordPress Post or Page
  84. How to detect if a revision was made by woocommerce or wordpress?
  85. WordPress WPDB::insert 13th param is always blank (only if format)
  86. Ajax not updating to database
  87. can’t delete a row from post_meta table
  88. MySQL query in WordPress with AJAX
  89. Processing forms with php to wordpress database
  90. How to connect database table to each registered wordpress user.
  91. retrieve wordpress post-meta using php not wordpress functions
  92. Splash pages on a high traffic site
  93. Using the same shortcode to show any table from the database
  94. I am unable to fetch json data from wp_db
  95. Submit cf7 form to cfdb as pdf/BLOB [closed]
  96. How to send push notification in android using php? [closed]
  97. Getting invalid user ID error when creating a new user with wp_insert_user
  98. Custom form that stores data in mysql database
  99. Putting form result in my database
  100. How can I update a value of a field depending on outside source?