keronsrus.blogg.se - Connect to digitalocean mysql sequel pro

#Connect to digitalocean mysql sequel pro generator

Step 4 - Enter your SSH and database credentials

#Connect to digitalocean mysql sequel pro generator

However, you can convert an existing PuTTY Private Key (ppk) file to OpenSSH format using the PuTTY Key Generator (PuTTYGen) utility. MySQL Workbench does not accept default PuTTY keys directly.

'The server's host key is unknown' warningĬonfirm that the fingerprint matches the one in your panel, then click the OK button.įinally, you'll see the successful connection message.

This is normal the first time you connect as you can read about here: The first time you connect, you may see a warning about the authenticity of the connection.

Click the OK button to log in to your database.Password: Click the Store in Keychain button to enter your database username's password.Username: Enter your database username.MySQL Hostname: Enter the hostname for your database.SSH Password: Click the Store in Keychain button to enter your SSH user's password.Connection Method: Select Standard TCP/IP over SSH.

Connection Name: Enter anything you like to name this new connection.

The following window opens for you to create a new connection. Step 3 - Enter your SSH and database credentials

Click the + icon to create a new connection.Creating a user with Shell (SSH) access.View the following article for instructions on allowing SSH access to your website user. Step 1 - Enable SSH for your website user This method is preferred over less secure methods as it provides point-to-point encryption and does not expose your MySQL account to potential hacks from allowed networks. This example uses MySQL Workbench to connect using an SSH tunnel.