Report this

What is the reason for this report?

Remote Connection to MariaDB on Ubuntu

Posted on December 22, 2017

I have set up maraDB and have been trying to connect to it remotely with no luck. I have read through a bunch of posts and have tried the following:

  1. I have looked in my.cnf to change the bind-address to 0.0.0.0.0 but have not found it defined anywhere

  2. Configured ufw to open port 3306

# ufw status
Status: active

To                         Action      From
--                         ------      ----
22                         ALLOW       Anywhere                  
3306/tcp                   ALLOW       Anywhere                  
3306                       ALLOW       Anywhere                  
22 (v6)                    ALLOW       Anywhere (v6)             
3306/tcp (v6)              ALLOW       Anywhere (v6)             
3306 (v6)                  ALLOW       Anywhere (v6) 

It hasn’t worked so far.

Using a suggestion from a post, it looks like mysql is only listening locally on port 3306.

# sudo lsof -iTCP -sTCP:LISTEN -P
COMMAND  PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
sshd    1540  root    3u  IPv4  15872      0t0  TCP *:22 (LISTEN)
sshd    1540  root    4u  IPv6  15881      0t0  TCP *:22 (LISTEN)
mysqld  3771 mysql   16u  IPv4  20248      0t0  TCP localhost:3306 (LISTEN)

Is there anyway to change this? Thanks for any help.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Start building today

From GPU-powered inference and Kubernetes to managed databases and storage, get everything you need to build, scale, and deploy intelligent applications.