Level 13
You are connecting to your db over SSH tunnel. You need to use the password for the tunnel connection.
Jun 19, 2015
8
Level 14
Connecting to Digital Ocean Mysql server with Sequel Pro
Hi all
I know this isn't a laravel question but after the day I'm having I really could do with the fantastic help of this community.
I've just created a new droplet with digital ocean to run my wordpress site. All has gone well until I try to connect Sequal Pro.
I am using the SSH tab in Sequal Pro and have entered the following details...
https://www.dropbox.com/s/81wrlkc7cc7sgbc/Screen-Shot-2015-06-19-at-12.52.32.png?dl=0
My Password is the one found in /root/.my.cnf
When attempting to connect I keep getting asked to put in my password for root@myipaddress.
Please note that I'm not using Forge.
Can anyone help me please? What am I doing wrong?
Thanks
Level 1
Assuming (for example) you added your .pub key to the user ~/.ssh/authorized_keys in your droplet os, just connect to your droplet ip address using ssh and provide your private key (eg. id_rsa file) and above in the mysql settings the mysql user using 127.0.0.1:3306.
Im using this setup in mysql workbench and sequel pro.
Level 14
@jimmck @diamondbybold thanks for answering guys. I'm sorry I don't know what you both mean.
I have added my key to the droplet but i'm not sure which fields on the Sequel Pro connection screen i'm supposed to complete after that. are the fields correct in the image?
Sorry it's been a long day!
Level 1
check here , if help: http://imgbox.com/tkFyEe27
4 likes
Level 14
@cvarandas Dude i owe you one BIG beer! Thanks!
1 like
Level 5
cheers from here as well
Level 14
@cvarandas after 1 year .. Big thank you <3
Level 32
@CVARANDAS - This worked so well! Thank you!!!
Please or to participate in this conversation.