Unable to Remote access MySQL installed on Ubuntu20.4

[jinkoban]

Hello All,

I have installed MySQL5.7 on an Ubuntu20.4 machine on AWS lightsail. I have created a user and granted all privileges. I have given static IP to the Ubuntu machine where MySQL is installed.

I'm trying to access the database from my windows machine. I can access the database using phpMyAdmin and putty using SSH, but UNABLE to access using MySQLWorkbench. I can't access the database from a Java App as well. I can see that the phpMyAdmin connection is using a UNIX Socket rather than TCP/IP. I also want to access the DB on a java app by entering the connection string, username and password, for which I am unable to.

I have opened the port 3306(ufw)

In my mysql.conf.d/mysqld.cnf, I have set up like below
bind-address = 0.0.0.0
port= 3306

My connection status shown is like below
Connection:Localhost via UNIX socket

Is there a way to change the socket connection to TCP/IP

Am I missing something? Thanks in advance

[QIII]

First, let's deal with Workbench.

You should be able to open Manage Server Connections by right-clicking on the connection and then clicking "Edit Connection". You can then set Connection Method to "Standard TCP/IP over SSH".

Are you getting an exception message?

[jinkoban]

Hi, Please find below the error that I'm getting without the ssh key file. It asks for the password though.

Couldnot connect to the SSH Tunnel
Unknown authentication type



If I add the .pem file from AWS, I get the below error

Couldnot connect to the SSH Tunnel
Authentication failed, access denied.

[jinkoban]

Error: https://www.dropbox.com/s/w41ckjsokn...error.PNG?dl=0