mysql-connector-python

v9.1.0

A self-contained Python driver for communicating with MySQL servers, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249). For more information about how to use this package see README

Latest version published 2 months ago

License: GPL-2.0

PyPI

GitHub

Package Health Score

90 / 100

security
No known security issues
popularity
Key ecosystem project
maintenance
Healthy
community
Sustainable

Explore Similar Packages

Popularity

Key ecosystem project

GitHub Stars: 882
Forks: 299
Contributors: 20

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package mysql-connector-python, we found that it has been starred 882 times.

Security

No known security issues

Security and license risk for latest version

Release Date: Oct 15, 2024
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
0
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

GPL-2.0

Non-Permissive License

We noticed that this project uses a license which requires less permissive conditions such as disclosing the source code, stating changes or redistributing the source under the same license. It is advised to further consult the license terms before use.

Security Policy

Yes

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Healthy

Commit Frequency

Open Issues: 0
Open PR: 0
Last Release: 2 months ago
Last Commit: 3 months ago

Further analysis of the maintenance status of mysql-connector-python based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Healthy.

We found that mysql-connector-python demonstrates a positive version release cadence with at least one new version released in the past 3 months.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Community

Sustainable

Readme: Yes
Contributing.md: Yes
Code of Conduct: No
Contributors: 20
Funding: No

With more than 10 contributors for the mysql-connector-python repository, this is possibly a sign for a growing and inviting community.

We found a way for you to contribute to the project! Looks like mysql-connector-python is missing a Code of Conduct.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: >=3.9

Age: 7 years
Latest Release: 2 months ago
Dependencies: 0 Direct
Versions: 31
Maintainers: 4
Wheels: OS Independent, Linux, macOS, Windows

Readme

MySQL Connector/Python

MySQL Connector/Python enables Python programs to access MySQL databases, using an API that is compliant with the Python Database API Specification v2.0 (PEP 249)

We refer to it as the Classic API.

Features

Installation

The recommended way to install Connector/Python is via pip.

Make sure you have a recent pip version installed on your system. If your system already has pip installed, you might need to update it. Or you can use the standalone pip installer.

$ pip install mysql-connector-python

Installation Options

Connector packages included in MySQL Connector/Python allow you to install optional dependencies to unleash certain functionalities.

# 3rd party packages to unleash the telemetry functionality are installed
$ pip install mysql-connector-python[telemetry]

This installation option can be seen as a shortcut to install all the dependencies needed by a particular feature. Mind that this is optional and you are free to install the required dependencies by yourself.

Available options:

dns-srv
gssapi
fido2
telemetry

Sample Code

import mysql.connector

# Connect to server
cnx = mysql.connector.connect(
    host="127.0.0.1",
    port=3306,
    user="mike",
    password="s3cre3t!")

# Get a cursor
cur = cnx.cursor()

# Execute a query
cur.execute("SELECT CURDATE()")

# Fetch one result
row = cur.fetchone()
print("Current date is: {0}".format(row[0]))

# Close connection
cnx.close()

Additional Resources

MySQL Connector/Python Developer Guide
MySQL Connector/Python Forum
MySQL Public Bug Tracker
Slack (Sign-up required if you do not have an Oracle account)
Stack Overflow
Oracle Blogs

Contributing

There are a few ways to contribute to the Connector/Python code. Please refer to the contributing guidelines for additional information.

License

Please refer to the README.txt and LICENSE.txt files, available in this repository, for further details.

FAQs

What is mysql-connector-python?

A self-contained Python driver for communicating with MySQL servers, using an API that is compliant with the Python Dat... Visit Snyk Advisor to see a full health score report for mysql-connector-python, including popularity, security, maintenance & community analysis.

Is mysql-connector-python popular?

The python package mysql-connector-python receives a total of 5,286,950 weekly downloads. As such, mysql-connector-python popularity was classified as a key ecosystem project. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is mysql-connector-python well maintained?

We found that mysql-connector-python demonstrated a healthy version release cadence and project activity. It has a community of 20 open source contributors collaborating on the project. See the full package health analysis to learn more about the package maintenance status.

Is mysql-connector-python safe to use?

The python package mysql-connector-python was scanned for known vulnerabilities and missing license, and no issues were found. Thus the package was deemed as safe to use. See the full health analysis review.

Last updated on 22 December-2024, at 08:46 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

Package Health Score

Explore Similar Packages

Direct Usage Popularity

Security and license risk for latest version

Commit Frequency

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Readme

MySQL Connector/Python

Features

Installation

Installation Options

Sample Code

Additional Resources

Contributing

License

FAQs

What is mysql-connector-python?

Is mysql-connector-python popular?

Is mysql-connector-python well maintained?

Is mysql-connector-python safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues