Power up with new SaaS Add-Ons from the DigitalOcean Marketplace

Question

Trying to connect to MySQL database server through MySQL Workbench using SSH

  • Posted January 8, 2015

I am having difficulty connecting to MYSQL database using Ubuntu server with Drupal application using SSH. I guess I’m not sure of the settings to put into the config screen.

SSH Hostname: my ip address SSH Username: root SSH Password: my server root pw SSH Password: Linked to putty key MySQL Hostname: 127.0.0.1 MySQL Server Port: 3306 Username: root password:MySQL pw

This does not let me in. Any suggestions? Ideas? I would like an easier way to access the databases without using terminal.

Also had trouble installing phpmyadmin on this pre-configured server.

Thanks, Mike

Subscribe
Share
bagman1673 • September 24, 2017

This comment has been deleted

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?

Kamal Nasser • January 9, 2015

Try converting your PuTTy key to the OpenSSH format:

  1. Open PuttyGen
  2. Click Load
  3. Load your private key
  4. Go to Conversions->Export OpenSSH and export your private key
  5. Leave the SSH Password field blank and select the converted private key

Does that work? Also, are you using MySQL’s root password or your Drupal MySQL user’s password?