Question

Remote login for MySQL no longer working

Posted on July 23, 2020
MySQL
Asked by zsmith126028

I have a MySQL database on my droplet which I was remote logging into and updating from a Python script for the last couple of months. I used this tutorial to get everything working (https://linuxize.com/post/mysql-remote-access/). It worked well until a couple days ago when I had to get a new modem and my local IP address changed for my PC. This is the only thing that has changed, so I’m assuming the problem stems from having to change my modem.

I went through the above link again, checking the bind address for MySQL, creating a new user in MySQL specific to the new IP address, granting the proper privileges, and allowing access to port 3306 through UFW. I also tried removing MySQL completely and reinstalling and I still cannot login remotely to MySQL.

I keep getting this error: ERROR 2002 (HY000): Can’t connect to MySQL server on ‘server ip address’ (115).

I’ve looked into how to fix this, but the only solutions I have found have to do with setting the bind address in /etc/mysql/mysql.conf.d/mysqld.cnf to 0.0.0.0 and allowing access to port 3306 with UFW, both of which I have done. Any ideas or solutions?

Submit an answer

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!

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.

Bobby Iliev

Site Moderator

• July 24, 2020

Accepted Answer

Hi there @zsmith126028,

I could suggest a couple of things:

First check if your MySQL is actually binding on 0.0.0.0:3306:

netstat -plant | grep 3306

Doublecheck your IP address, you could do that by visiting this site here: http://ifconfig.io/ or running the following command:

curl http://ifconfig.io/

Note that if you have a dynamic IP address, you would need to allow your whole IP range so that you don’t lose your SQL connection every time your IP changes.

Let me know how it goes! Regards, Bobby