Connecting to Redshift from SQLWorkbench

Download SQL Workbench

Download Redshift JDBC driver

Start sqlworkbench

cd ~/Downloads/Workbench-Build125 && java -jar sqlworkbench.jar &

Create new connection

URL: jdbc:

redshift://my-cluster.my-database.us-east-1.redshift.amazonaws.com:5439/databasename?ssl=true&sslfactory=com.amazon.redshift.ssl.NonValidatingFactory

Redshift connect

 

Use this script to create md5 password hash

#!/bin/bash
echo -n "Enter Username: "
read username
if [ ${#username} -lt 1 ]
then
    echo "Username cannot be empty"
    exit 1
fi
echo -n "Enter Password: "
read -s password
if [ ${#password} -lt 1 ]
then
    echo "Password cannot be empty"
    exit 1
fi
echo -n -e "\rVerify Password: "
read -s password_verify
if [ "$password" != "$password_verify" ] 
then
    echo "Passwords do not match"
    exit 1
fi
echo "OK"
echo "md5$(md5 -q -s "$password$username")"