Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
2.5k views
in Computer by (15 points)

Please log in or register to answer this question.

1 Answer

0 votes
by (48.4k points)
To test database connection here we use pre-installed MySQL connector and pass credentials into connect() function like host, username and password.

Syntax to access MySQL with Python:

    import mysql.connector
    db_connection = mysql.connector.connect(
      host="hostname",
      user="username",
      passwd="password"
    )
Example,

import mysql.connector
db_connection = mysql.connector.connect(
  host="localhost",
  user="root",
  passwd="root"
)
print(db_connection)

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...