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

Options: ReplyQuote


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


Sorry, only registered users may post in this forum.

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.