Connecting to Redshift from SQLWorkbench
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
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")"