Python installation and database configuration step by step

1. Download latest python 3.7 & xampp for mysql databases

2. Install python 3.7

After successfully download python, then Click on setup files and then install it.

Instalation steps

3. Check python & pip version by commands

Use this command to check python version.

User this command to check pip versions.

4. Pip not install then use this command for install.

Installing with get-pip.py. To install pip, securely download get-pip.py.
run this command -

5. Install PyMySQL library.

For Installing PyMySQL library.
run this command -

6. Create a file db.py Database connection code.

create a db.py file with below code.

    
    import pymysql

    conn = pymysql.connect(host='localhost', port=3306, user='root', passwd='root', db='user')

    cur = conn.cursor()
    cur.execute("SELECT * FROM user_email")

    print(cur.description)
    print()

    for row in cur:
    print(row)

    cur.close()
    conn.close()
    
                

Create a database & table and insert dummy records.

You have to know basic about phpmyadmin and mysql. Firstly you have to learn how to create a database and table then run this code. open phpmyadmin for a database and tabel - localhost/phpmyadmin.
Databasename - user.
Tabelname - user_email

7. Finally run Database connection code.

Run python database connection code.that code put in c:/apy/db.py
run this command -