Category: Python

On the host machine, it is required to install the driver to connect to the database from the Python code.

On Ubuntu or Debian-based Linux systems:

apt-get install python-mysql.connector

On Redhat or CentOS Linux systems:

yum install python-mysql.connector

Connect to the database server using the command line client, then  the database to connect to:

CREATE DATABASE flask DEFAULT CHARACTER SET utf8 DEFAULT collate utf8_bin;

GRANT ALL PRIVILEGES ON flask.* to flaskuser@'%' IDENTIFIED BY 'flaskuser';
GRANT ALL PRIVILEGES ON flask.* to flaskuser@'localhost' IDENTIFIED BY 'flaskuser';

SET PASSWORD FOR 'flaskuser'@'localhost' = PASSWORD('<PASSWORD>!');

Finally, from the Python script, import the connector, connect to the database, and start querying the records:

#!/usr/bin/env python

import mysql.connector as mariadb

mariadb_connection = mariadb.connect(user='flaskuser', password='<PASSWORD>', database='flask')
cursor = mariadb_connection.cursor()