Couldn't connect to remote sql on sequel Pro

December 26, 2018 1.6k views
MySQL

Hi, everything is working fine on my instance. However, when I connect to my-ip-address with 3306, I couldn’t connect to sql server from Sequel Pro.

mysql -u admin -h my-ip-address -p
I can login with password, there is no problem.

nano /etc/mysql/my.cnf

bind-address = my-address-ip
#skip-networking

/etc/mysql/mysql.conf.d/mysqld.cnf

# bind-address          = 127.0.0.1
bind-address    = my-address-ip

sudo netstat -plunt | grep mysqld

tcp        0      0 my-ip-address:3306     0.0.0.0:*               LISTEN      2926/mysqld

sudo lsof -iTCP -sTCP:LISTEN -P

COMMAND  PID     USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
sshd    1458     root    3u  IPv4  15120      0t0  TCP *:22 (LISTEN)
sshd    1458     root    4u  IPv6  15130      0t0  TCP *:22 (LISTEN)
apache2 1566     root    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 1589 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 1590 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 1592 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 1594 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 2021 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 2023 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 2024 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 2056 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 2057 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
apache2 2058 www-data    4u  IPv6  16134      0t0  TCP *:80 (LISTEN)
mysqld  2926    mysql   14u  IPv4  23229      0t0  TCP my-ip-address:3306 (LISTEN)

Thanks you.

2 Answers

Hey friend,

Seems like you’ve pretty much covered it. I have one idea though. Try changing the grant privileges for a MySQL user to specify your local IP address. There’s a guide on it here:

https://easyengine.io/tutorials/mysql/remote-access

Jarland

  • Hello,
    I tried the method, and it worked with ssh credential on Sequal app.

    Is there a way to connect remote mysql without SSH ?

Have another answer? Share your knowledge.