Kashipara.com is a community of 5.00 lakh programmers and students, just like you, helping each other.Join them; it only takes a minute: Sign Up


Python installation and database configuration step by step


1. Download latest python 3.7 & xampp for mysql databases

Download latest version of python i.e 3.7. After successful download install it. https://www.python.org/downloads/ Download python 3.7

Here you can download latest version of xampp, and then install it. https://www.apachefriends.org/download.html Download xampp


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.

cmd > python

User this command to check pip versions.

cmd > pip --version


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 -

curl https://bootstrap.pypa.io/get-pip.py -o get-pip.py
Then run the following:
python get-pip.py


5. Install PyMySQL library.

For Installing PyMySQL library.
run this command -

pip3 install PyMySQL

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 -

python db.py