python-mysqlHow can I connect Python to a MySQL database?
To connect Python to a MySQL database, you can use the mysql.connector
module. This module is part of the MySQL Connector/Python package.
In order to connect to a MySQL database, you will need to have the following information:
- Host name (e.g.
localhost
or127.0.0.1
) - User name
- Password
- Database name
The following example code connects to a MySQL database and prints out the version of the MySQL server:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
passwd="yourpassword",
database="mydatabase"
)
print(mydb.get_server_info())
Output example
8.0.19
For more information, see the MySQL Connector/Python Developer Guide.
More of Python Mysql
- How do I use Python to authenticate MySQL on Windows?
- How can I access MySQL using Python?
- How can I use the "order by" statement in Python to sort data in a MySQL database?
- How do I download MySQL-Python 1.2.5 zip file?
- How can I use Python to interact with a MySQL database using YAML?
- How do I count the number of rows in a MySQL database using Python?
- How can I connect Python and MySQL?
- ¿Cómo conectar Python a MySQL usando ejemplos?
- How can I use Yum to install the MySQLdb Python module?
- How can I connect Python to a MySQL database using an Xserver?
See more codes...