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:
# ..... ! ..... ! ..... [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
|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!
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.