Question

Couldn't connect to remote sql on sequel Pro

  • Posted December 26, 2018
  • 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.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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

This comment has been deleted