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.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
This comment has been deleted
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
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.