0

I have django project in which I can display records from raspberry pi device. I had mysql database and i have send records from raspberry there. I can display it via my api, but I want to work on this records.I want to change this to django database but I don't know how I can get access to django database which is on VPS server from raspberry pi device.

Shadow
  • 33,525
  • 10
  • 51
  • 64
Komin
  • 3
  • 1
  • Possible duplicate of [How do I connect to a MySQL Database in Python?](https://stackoverflow.com/questions/372885/how-do-i-connect-to-a-mysql-database-in-python) – Jacques Gaudin Apr 15 '19 at 15:10

1 Answers1

0

ALERT: THIS CAN LEAD TO SECURITY ISSUES

A Django database is no different from any other database. In this case a MySQL.

The VPS server where the MySQL is must have a public IP, the MySQL must be listening on that IP (if the VPS has a public IP but MySQL is not listening/bind on that IP, it won't work) and the port of the MySQL open (default is 3306), then you can connect to that database from any program with the required configurations params (host, port, user, password,...).

I'm not a sysadmin expert, but having a MySQL on a public IP is a security hole. So the best approach IMO is to expose the operations you want to do via API with Django.

grouchoboy
  • 1,016
  • 8
  • 12