How to Connect Python to MySQL Database and Display Data
In This Python Tutorial We Will See How To Connect Python To MySQL DataBase Using PIP in VsCode.
Source Code:
import mysql.connector
connection = mysql.connector.connect(
host='localhost',
user='root',
password='',
port='3306',
database='test_py'
)
c = connection.cursor()
select_query = 'SELECT * FROM `users_2`'
c.execute(select_query)
data = c.fetchall()
# display data
for row in data:
print(row)
OUTPUT:
