python-mysqlHow do I connect to a MySQL database using Python?
To connect to a MySQL database using Python, you need to use a MySQL Connector. MySQL Connector/Python is a standardized database driver for Python platforms and development.
To connect to a MySQL database with Python, you need to use the following steps:
- Install MySQL Connector Python using the pip command:
pip install mysql-connector-python
- Import the MySQL Connector Python module in your program:
import mysql.connector
- Establish a connection to the MySQL database by creating a new MySQLConnection object:
mydb = mysql.connector.connect(host="localhost", user="yourusername", passwd="yourpassword")
- Create a new cursor object from the connection:
mycursor = mydb.cursor()
- Execute a SQL query:
mycursor.execute("SELECT * FROM customers")
- Fetch the results:
myresult = mycursor.fetchall()
- Print the results:
for x in myresult: print(x)
The output of the above code is a list of records from the customers table:
('John', 'Highway 21')
('Peter', 'Lowstreet 4')
('Amy', 'Apple st 652')
('Hannah', 'Mountain 21')
('Michael', 'Valley 345')
('Sandy', 'Ocean blvd 2')
('Betty', 'Green Grass 1')
('Richard', 'Sky st 331')
('Susan', 'One way 98')
('Vicky', 'Yellow Garden 2')
('Ben', 'Park Lane 38')
('William', 'Central st 954')
('Chuck', 'Main Road 989')
('Viola', 'Sideway 1633')
Helpful links
More of Python Mysql
- How do I connect Python with MySQL using XAMPP?
- How can I use Python Kivy with MySQL?
- How can I use Python and MySQL to generate a PDF?
- How can I connect Python and MySQL?
- How can I connect Python to a MySQL database?
- How can I use Python to interact with a MySQL database using YAML?
- How do Python MySQL and SQLite compare in terms of performance and scalability?
- How can I connect Python to a MySQL database using an Xserver?
- How do I use Python to query MySQL with multiple conditions?
- How can I use a while loop in Python to interact with a MySQL database?
See more codes...