MySQL through Workbench

May 28, 2018 364 views
MySQL Ubuntu

Hi guys, I know there are already threads about this but somehow I kept on missing something. So I decided to put it here. I'm new to SSH and basically anything about this (but I know MySQL) so I'm really trying hard to understand these stuff lol. So please bear with me.

I wanted to access MySQL through Workbench. Here's what I did so far:

  • Successfully setup my Droplet with an IPv4 and a private IP (I'm confused which I should use).
  • Got the console running and updated my mysqld.cnf file:
# .....
! .....
! .....
[mysqld]
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/English
bind-address    = 0.0.0.0
# skip-networking
  • Restarted service after that.
  • Then through my Workbench I selected Standard TCP/IP over SSH with the following entries:
Field Value
SSH Hostname (Private IP Address, also tried the public IPv4)
SSH Username root
SHH Password (Droplet password)
SSH Key File Exported OpenSSH key PuTTYGen with no Key passphrase
MySQL Hostname 127.0.0.1
MySQL Server Port 3306
Username root
Password (MySQL password)
Default Schema

Using the public IP I get a fingerprint mismatch.
Using the private IP, I get no response at all.

Feel free to ask more details. Enlighten me please!

1 Answer

UP

Having the exact same problem, can only connect though putty. No Workbench access nor web app access

Have another answer? Share your knowledge.