Code for How to Connect to a Remote MySQL Database in Python Tutorial

View on Github

import mysql.connector as mysql

# enter your server IP address/domain name
HOST = "x.x.x.x" # or ""
# database name, if you want just to connect to MySQL server, leave it empty
DATABASE = "database"
# this is the user you create
USER = "python-user"
# user password
PASSWORD = "Password1$"
# connect to MySQL server
db_connection = mysql.connect(host=HOST, database=DATABASE, user=USER, password=PASSWORD)
print("Connected to:", db_connection.get_server_info())
# enter your code here!


/* '%' means from any where in the world*/
CREATE USER 'python-user'@'%' IDENTIFIED BY 'Password1$';
/* grant all privileges to the user on all databases & tables available in the server */
GRANT ALL ON *.* TO 'python-user'@'%';