Problem
How do I connect to a Spinup MySQL database?
Solution
There are a number of clients you may use to connect to a Spinup PostgreSQL database (see https://wiki.postgresql.org/wiki/PostgreSQL_Clients).
To test the initial connection we recommend using the official psql client on the command line.
From a machine with the psql client installed, you may just type:
psql -h DATABASEURL -U USERNAME DATABASENAME
Note that the default database is called postgres - once you connect initially you can create additional ones.
E.g. the connection may look like this:
psql -h spinup-db0005a1.cyynsscieqtk.us-east-1.rds.amazonaws.com -U root postgres
After clicking enter, you will be asked for the password (the one given when creating the database - which you can reset at any time).
That's it! - At this point you have full administrator rights on the database and can create or drop tables, add or delete data, etc.
Note: When connecting to the database always use SSL encryption. If you use the psql client this is done automatically but when connecting from an application you may need to explicitly enable encryption.
Related articles