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