mysql for python installation

Using MySQL database in Python can be achieved by installing libraries such as mysql-connector-python or PyMySQL, and mysql-connector-python is supported by the native MySQL official library.

This article will introduce the mysql-connector-python library that needs to be installed when using MySQL database in Python.

1. Download mysql-connector-python
We can download the stable version of mysql-connector-python from the official website of MySQL, the download address is https://dev.mysql.com/downloads/connector/ python/. You can find the download link at the bottom of the page, select the latest version to download.

2. Install mysql-connector-python
There are two ways to install mysql-connector-python, one is to install through pip, and the other is to install through source code.

2.1 Install through pip
pip3 install mysql-connector-python

2.2 Install through source code

Unzip the downloaded mysql-connector-python source code file and enter the decompression folder, and then execute the setup.py installation script.

tar -zxvf mysql-connector-python-.tar.gz
cd mysql-connector-python-
python setup.py install

3. Test mysql-connector-python
Use the following python program to test mysql-connector-python:

Import mysql-connector-python module

import mysql.connector

Establish connection

conn = mysql.connector.connect(user='root', password='password', host='127.0.0.1', database='test')

Execute query

cursor = conn.cursor()
cursor.execute('select * from students')
result = cursor.fetchall()
print(result)

Close the connection

cursor.close()
conn.close()

where user is your MySQL username, password is your MySQL password, and host is you The IP address of the server where MySQL is located, database is the name of the database you want to connect and operate.

After running the above program, if no error is reported and the results of the query from the database are output, the installation is successful.

4. Summary
mysql-connector-python is one of the important libraries for using MySQL database in Python. By installing the mysql-connector-python library, you can easily and quickly connect to the MySQL database and perform various routines. operate.

The process of installing mysql-connector-python is very simple and can be installed through pip or source code. Before installing, make sure that Python has acquired appropriate network connectivity.

In addition, if you use Python's ORM framework, this library is also recommended when operating MySQL database.

The above is the detailed content of mysql for python installation. For more information, please follow other related articles on the PHP Chinese website!