MySQL Forums
Forum List  »  MySQL Workbench

Unable to Remote access MySQL installed on Ubuntu20.4
Posted by: Shibin Jose
Date: January 23, 2021 04:53AM

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 =
port= 3306

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

Am I missing something? Thanks in advance

Options: ReplyQuote

Written By
Unable to Remote access MySQL installed on Ubuntu20.4
January 23, 2021 04:53AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.