Can you connect to a database on another pc?

Question

I'm using MySQLdb for python, and I would like to connect to a database hosted on an other PC on the same network/LAN.
I tried the followings for host:

192.168.5.37  
192.168.5.37:3306  
http://192.168.5.37
http://192.168.5.37:3306

None of the above work, I always get the

2005, Unknown MySQL server host ... (0)

What might be the problem?

Code:

db = MySQLdb.connect(host="192.168.5.37", user = "root" passwd = "password", db = "test1")

Well, certainly `http://` does not help. What makes you think that MySQL uses the HTTP protocol? Can you `ping 192.168.5.37` from a terminal on your local machine? — Tobia Tesan, Nov 19 '15 at 13:58
I tried pinging it several times, I got a response each time. — Fe Ri, Nov 19 '15 at 13:59
How does your connection set-up look like. please post some code — JDurstberger, Nov 19 '15 at 14:01
Possible duplicate of [Connect on remote MySQL database through Python](http://stackoverflow.com/questions/12972867/connect-on-remote-mysql-database-through-python) — Pynchia, Nov 19 '15 at 14:02
If Tom Ron's command shows the port is open, next try to actually connect through the mysql command, `mysql -h 192.168.5.37 -u root -p -D test1`. See if it works. — spectras, Nov 19 '15 at 14:27

Kenly · Answer 1 · 2015-11-19T14:31:22.297

You can use MySQL Connector/Python, a standardized database driver for Python.
You must provide username, password, host, database name.

import mysql.connector

conn = mysql.connector.connect(user=username, password=password,
                          host="192.168.5.37",
                          database=databaseName)
conn.close()

You can download it from: https://dev.mysql.com/downloads/connector/python/

score -1 · Answer 2 · answered Nov 19 '15 at 14:00

-1

The IP you posted are local IPs Give it a try with your external IP (for example on this website) https://www.whatismyip.com/

If it works with the external IP, then it's maybe a misconfiguration of your firewall.

answered Nov 19 '15 at 14:00

Germain

658
7
19

Not helpful at all. He said the machines are on the same network. Also, a "local IP" would be 127.0.0.1. – waka Nov 19 '15 at 14:02

Can you connect to a database on another pc?

2 Answers2

Linked