![]() Going off the screenshot, the host would be 54.172.123.217, the username would be bitnami and the private key file can be downloaded by clicking “Download default key”. You can find all 3 of those on the “Connect” tab for your Lightsail instance in the AWS console. You’ll also need the host, username, and private key file. ![]() The SSH port you want to connect on is 22. One is the port, and I’ll give that to you know. There are 4 pieces of info needed for the SSH connection. All you need to do is gather a few extra connection details when configuring the GUI connection. TablePlus, MySQL Workbench, and many others support database connections over SSH. So your GUI will SSH into the Lightsail instance and then connect to the local database process. Instead, you’ll need to connect to the database over SSH. There’s no external database IP you can directly connect to from your local machine. The steps to reproduce this issue: PostgreSQL 10.10 build 264 Mariadb 10.1. The database you’re trying to connect to is running as a local process on your Lightsail instance. This will also work for any database GUI that supports SSH connections. In this post, I’ll show you how to connect to the database from TablePlus and MySQL Workbench. How do I connect to the Lightsail database from the GUI I use on my Mac? ![]() I got the WordPress sites up and running, but I ran into an issue. I was looking for an easy way to spin up multiple WordPress websites for a plugin I’m working on and Lightsail was exactly the kind of tool I wanted. We will also learn how to setup and use TablePlus to connect and interact with Postgres, and use it to run the SQL script that we’ve generated in the previous lecture to create our Simple Bank’s database schema. Earlier this summer I learned about AWS Lightsail. Today we will learn how to install Docker Desktop on local machine, then download and start a PostgreSQL container.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |