MySQL through Workbench
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:
|SSH Hostname||(Private IP Address, also tried the public IPv4)|
|SHH Password||(Droplet password)|
|SSH Key File||Exported OpenSSH key PuTTYGen with no Key passphrase|
|MySQL Server Port||3306|
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!