Connecting to mysql from another network (MacOS)

Question

I have a mysql database running on my home computer and I want to access it from other networks (a laptop when I leave the house).

I followed a few posts and set up privileges:

+-----------------------------------------------------------+
| Grants for test@%                                         |
+-----------------------------------------------------------+
| GRANT USAGE ON *.* TO 'test'@'%'                          |
| GRANT ALL PRIVILEGES ON `database`.`table` TO 'test'@'%'  |
+-----------------------------------------------------------+

I am using SQLAlchemy to connect to the DB:

engine = create_engine('mysql://test:my_password@my_home_computer_ip_address:3306/table')

However I am getting this error:

sqlalchemy.exc.OperationalError: (_mysql_exceptions.OperationalError) (2003, "Can't connect to MySQL server on 'my_ip_address' (61)")

What am I doing wrong?

Leaving MySQL open is an invitation to trouble. You may want to open SSH with password authentication disabled instead and use that to tunnel in as SSH is generally less vulnerable to attacks than MySQL. Remember the default MySQL protocol is not encrypted. — tadman
– tadman, Commented Oct 2, 2017 at 15:53
Here's a generic answer with most of the requirements: Successfully connect Client to MySQL server — Jacques Amar
– Jacques Amar, Commented Oct 2, 2017 at 18:04

Alex Baranowski · Accepted Answer · 2017-10-02 14:21:43Z

1

Two things always to check when accessing some not working service on remote computer.

Can you ping this computer?
Can you telnet to service (telnet my_sql_host my_sql_port)?

If there is fail on first step your network configuration is probably wrong. Fail on second step suggest firewall or service misconfiguration.

There is still possibility that there is another source of problem, but these are the most basic checks.

answered Oct 2, 2017 at 14:21

Alex Baranowski

1,10414 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

dropWizard Over a year ago

for telnet, my_sql_host is my ip address?

dropWizard Over a year ago

I got a connection refused for telnet ip_address 3306

Alex Baranowski Over a year ago

It's address of my_home_computer_ip_address

Alex Baranowski Over a year ago

So there might be problem with firewall or with service. Is this machine that has mySQL server running on Linux?

Alex Baranowski Over a year ago

I don't have MacOS - but according to internet you can check running ports with netstat. netstat -tlnp. Check if mysql is listening on 3306

Jacques Amar · Accepted Answer · 2017-10-02 18:22:27Z

0

Here's a generic answer to MySQL connection problems from the outside:

MYSQL Connection

answered Oct 2, 2017 at 18:22

Jacques Amar

1,8231 gold badge12 silver badges12 bronze badges

Collectives™ on Stack Overflow

Connecting to mysql from another network (MacOS)

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related