Python using MySQL sample

Install MySQL Driver

Because the MySQL server runs in a separate process and serves the network externally, it is necessary to support the MySQL driver for Python to connect to the MySQL server. MySQL officially provides the Mysql-connector-python driver, but when installed, you need to add parameters to the PIP command --allow-external :

Pip Install Mysql-connector-python--allow-external Mysql-connector-python

If the above command fails to install, you can try another driver:

Pip Install Mysql-connector

We show how to connect to the MySQL server's database:

ImportMysql.connectorconn= Mysql.connector.connect (user='Root', password='123456', database='Javaweb') Cursor=conn.cursor () cursor.execute ("SELECT * FROM commodity") Values=Cursor.fetchall () forValueinchvalues:Print(value) cursor.close () conn.close ()

Python using MySQL sample