Python - Connecting to MariaDB Server

# Module Imports

import mariadb

import sys

​

try:

    conn = mariadb.connect(

        user="root",

        password="root",

        host="127.0.0.1",

        port=3306,

        database="my_workspace"

​

    )

except mariadb.Error as e:

    print(f"Error connecting to MariaDB Platform: {e}")

    sys.exit(1)

​

# Get Cursor

cur = conn.cursor()

some_name = "Sales" 

cur.execute("SELECT Emp_Name,Dept_Name FROM EMPLOYEE WHERE Dept_Name=?", (some_name,)) 

​

for first_name, last_name in cur: 

    print(f"First name: {first_name}, Last name: {last_name}")

First name: Ramesh, Last name: Sales
First name: Suresh, Last name: Sales
First name: Rajesh, Last name: Sales
First name: Shyamu, Last name: Sales
First name: Ramu,   Last name: Sales
First name: Mahesh, Last name: Sales