How to make database connection

Nigel Goodwin said:

I've only ever done it using MYSQL, PHP and a webserver, so essentially accessing it as if it was a remote Internet database - and in fact while I used to set up a home computer just to do that, I now just do it on my external webspace which includes PHP etc.

But a simple google search instantly clears your query:

Python MySQL

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

Click to expand...

import mysql.connector

mydb = mysql.connector.connect(
  host="192.168.45.5",
  user="simple",
  password="Samy@123",
  database = "test"
)

print(mydb)