Breaking News: Grepper is joining You.com. Read the official announcement!

connecting python with database

Add Answer

Outrageous Ostrich answered on April 10, 2022 Popularity 10/10 Helpfulness 5/10

answer connecting python with database

related connecting to mysql database using python

related how to connect database in python

connecting python with database

Comment

import mysql.connector
from mysql.connector import Error
try:
    connection = mysql.connector.connect(host='localhost',
                                         database='techshop',
                                         user='root',
                                         password=' ')
    if connection.is_connected():
        db_Info = connection.get_server_info()
        print("Connected to MySQL Server version ", db_Info)
        cursor = connection.cursor()
        cursor.execute("select database();")
        record = cursor.fetchone()
        print("You're connected to database: ", record)
except Error as e:
    print("Error while connecting to MySQL", e)
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed")

Popularity 10/10 Helpfulness 5/10 Language python

Source: softhunt.net

Tags: database python

Link to this answer
Share Copy Link

Contributed on Apr 10 2022

Outrageous Ostrich

0 Answers Avg Quality 2/10

Closely Related Answers

connecting to mysql database using python

Comment

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='Electronics',
                                         user='pynative',
                                         password='pynative@#29')
    if connection.is_connected():
        db_Info = connection.get_server_info()
        print("Connected to MySQL Server version ", db_Info)
        cursor = connection.cursor()
        cursor.execute("select database();")
        record = cursor.fetchone()
        print("You're connected to database: ", record)

except Error as e:
    print("Error while connecting to MySQL", e)
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed")

Popularity 10/10 Helpfulness 5/10 Language sql

Source: pynative.com

Tags: database databas

Link to this answer
Share Copy Link

Contributed on Jun 05 2022

Courageous Cod

0 Answers Avg Quality 2/10

how to connect database in python

Comment

import mysql.connector
from mysql.connector import Error

try:
    connection = mysql.connector.connect(host='localhost',
                                         database='Electronics',
                                         user='pynative',
                                         password='pynative@#29')
    if connection.is_connected():
        db_Info = connection.get_server_info()
        print("Connected to MySQL Server version ", db_Info)
        cursor = connection.cursor()
        cursor.execute("select database();")
        record = cursor.fetchone()
        print("You're connected to database: ", record)

except Error as e:
    print("Error while connecting to MySQL", e)
finally:
    if connection.is_connected():
        cursor.close()
        connection.close()
        print("MySQL connection is closed")

Popularity 9/10 Helpfulness 3/10 Language python

Source: Grepper

Tags: connect

Link to this answer
Share Copy Link

Contributed on May 16 2022

Ankit Aggarwal

0 Answers Avg Quality 2/10

connecting python with database

Contents

More Related Answers

connecting python with database

Closely Related Answers

connecting to mysql database using python

how to connect database in python

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.