python-mysqlHow can I connect Python and MySQL?
To connect Python and MySQL, you can use the mysql.connector
module. This module provides an API which can be used to connect to a MySQL database.
Example code
import mysql.connector
# Connect to the database
conn = mysql.connector.connect(
host="localhost",
user="user",
passwd="password",
database="mydatabase"
)
# Print the connection object
print(conn)
Output example
<mysql.connector.connection_cext.CMySQLConnection object at 0x7f3c3f8f7e10>
The code above does the following:
- Imports the
mysql.connector
module. - Connects to the database using the
connect
method. This requires passing in the host, user, password, and database name as parameters. - Prints out the connection object.
Helpful links
More of Python Mysql
- How can I use Python to yield results from a MySQL database?
- How do Python MySQL and SQLite compare in terms of performance and scalability?
- How can I convert a MySQL query result to a Python dictionary?
- How do I decide between using Python MySQL and PyMySQL?
- How do I connect Python to a MySQL database using Visual Studio Code?
- How do I download MySQL-Python 1.2.5 zip file?
- How can I use Python and MySQL to generate a PDF?
- How can I use Python and MySQL to create a login system?
- How can I connect to a MySQL database using Python and SSH?
- How do I use Python to connect to a MySQL database using XAMPP?
See more codes...