Unable to Remote access MySQL installed on Ubuntu20.4

[Shibin Jose]

Hello All,

I have installed MySQL5.7 on an Ubuntu 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 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

Am I missing something? Thanks in advance