Fewpal
0 votes
18 views
in Computer by (15 points)

Please log in or register to answer this question.

1 Answer

0 votes
by (50.1k 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

...