Python Connector for MySQL
Python Connector for MySQL boxshot
Version
1.4.0
License
Shareware
Trial Limitations
30-day free trial, evaluation use only, not for production
Operating Systems
Windows 32-bit and 64-bit, Windows Server, macOS 64-bit and ARM (Apple silicon), Linux 64-bit
System Requirements
Python 3.10 to 3.15. Windows 32/64-bit, Windows Server, macOS 64-bit and Apple silicon, Linux 64-bit. MySQL 3.23 to 9.7 or MariaDB 5.x to 12.x. No MySQL client library needed
File Size
3.91 MB
Release Date
10/22/2026
Last Updated
11/15/2026
8 views 0 downloads
DB API 2.0 Python connector for MySQL and MariaDB, no client library needed

Devart Python Connector for MySQL: A Commercial DB API Driver for MySQL and MariaDB

Devart Python Connector for MySQL is a paid Python database module, $74.95 a year for one developer, that connects Python 3.10-3.15 code on Windows, macOS and Linux straight to MySQL and MariaDB servers, including Amazon Aurora, Amazon RDS, Azure and Google Cloud. It follows the Python DB API 2.0 standard, installs with pip, and adds SSH and HTTP tunneling, connection pooling and support for MySQL versions back to 3.23.

Most Python developers reach for a free MySQL library first, and for many projects that's the right call. Devart's connector is aimed at the cases where the free options get awkward: a database that's only reachable through an SSH jump host or an HTTP tunnel, a very old MySQL server, or a company that wants a vendor to call when the driver misbehaves.

Quick facts

  • Version: 1.4.0, released October 22, 2026; first released December 1, 2023
  • Developer: Devart
  • Package: pip install devart-mysql-connector, or wheel files from Devart's download page (3.91 MB for Windows)
  • Python: 3.10 to 3.15 (1.4 dropped 3.7 to 3.9)
  • Servers: MySQL 3.23 to 9.7, MariaDB 5.x to 12.x, Azure Database for MySQL, Amazon RDS for MySQL, Amazon Aurora, Google Cloud for MySQL
  • Platforms: Windows 32-bit and 64-bit (and Windows Server), macOS Intel and Apple silicon, Linux 64-bit
  • Price: $74.95 a year or $149.95 perpetual for a Single (one developer) license
  • Trial: 30 days, for evaluation only, not for production use
  • Refund: the order page promises a 30-day money-back guarantee "if you are not satisfied", while Devart's ordering FAQ grants refunds within 30 days only when a technical problem support can't fix stops the product working
  • What we checked: the order page charged $74.95 for a Single license with one year of updates on a yearly subscription, and PyPI and Devart's download page both showed version 1.4.0 with wheels for Python 3.10 to 3.15, on November 15, 2026. We didn't run it against a MySQL server

Download Free Trial Buy Now

Overview

Using it looks like any DB API module: import devart.mysql as mysql, then mysql.connect(Server=..., Database=..., UserId=..., Password=...), a cursor, execute() and fetchall(). Parameters use ? placeholders passed as a list or tuple, which keeps values out of the SQL string and protects against injection.

The connector talks to the server over TCP/IP itself, so there's no MySQL client library to install on each machine, and it ships as compiled wheels for each Python version and platform. A license is activated in code with devart.mysql.license.activate("<key>"), and devart.mysql.license.summary shows what's installed.

Features

SSH and HTTP tunnels built in

Devart Python Connector for MySQL can reach a server through an SSH tunnel or an HTTP/HTTPS tunnel as well as over SSL/TLS, with no separate tunnelling tool. Version 1.3 added password-protected private keys for SSL and bearer-token authentication for the HTTP tunnel, which helps when a hosted MySQL database only accepts web traffic.

Connection pools you can tune

Devart Python Connector for MySQL pools connections once you set connection_pool.enabled = True, with min_size, max_size, lifetime and validate settings and several numbered pools selected by a PoolId. Pooled connections are checked every 30 seconds, idle ones are dropped after about four minutes, and one fatal error triggers a check of the whole pool.

Old and new servers alike

Devart Python Connector for MySQL covers MySQL from 3.23 up to 9.7 and MariaDB 5 to 12, including MariaDB's UUID, INET4 and INET6 types and generated columns. Version 1.4 added LDAP SASL authentication with GSSAPI (Kerberos) and handling of MySQL's interactive-timeout error packet.

Batches and type control

Devart Python Connector for MySQL can send several update statements to the server as one batch, and has options for how MySQL and MariaDB types map to Python types. It's Unicode-compliant for multilingual data.

Benefits

  • One less moving part. SSH or HTTP tunnelling lives in the connection settings instead of in a separate process.
  • Simple deployment. A pip install, no MySQL client libraries on each user's PC.
  • Legacy servers covered. Scripts can still talk to MySQL 4 or 5.0 boxes that newer libraries no longer support.
  • A vendor behind it. Paid support and regular releases tied to new Python and MySQL versions.

Real-World Uses

  • Reporting through a bastion host. A data analyst's Python script reaches a production MySQL server that only allows SSH, without setting up port forwarding by hand.
  • Web app on MariaDB. A Flask or Django-style service keeps a tuned connection pool open to MariaDB 11.
  • Moving data off an old server. A script reads tables from a MySQL 5.0 machine and loads them into Aurora.
  • Corporate sign-on. Scripts connect with Kerberos through LDAP SASL GSSAPI instead of stored passwords.

Who It's For, and Who Should Skip It

The connector suits Python developers and data teams in companies that need tunnelled or Kerberos connections, support for unusual MySQL versions, or a commercially supported driver with a license and support contract behind it.

Skip it if you're writing a hobby project or open-source library: the license forbids building Python packages on it for public distribution or sale, and free MySQL drivers such as Oracle's MySQL Connector/Python and PyMySQL cover ordinary connections. It also won't help with Python 3.9 or older.

Usage Guide

  1. Install with pip install devart-mysql-connector, or download the zip of wheels for your Python version and run pip on the .whl file.
  2. After buying, copy the activation key from the order email or Devart's customer portal and run devart.mysql.license.activate("<key>") once.
  3. Connect: my_connection = mysql.connect(Server="db.example.com", Database="shop", UserId="report", Password="..."), adding SSL, SSH or HTTP tunnel parameters as needed.
  4. Query: cur = my_connection.cursor(), cur.execute("SELECT id, name FROM customers WHERE country = ?", ["DE"]), cur.fetchall().
  5. For a web app, turn on pooling with devart.mysql.connection_pool.enabled = True and set max_size and lifetime.

Before you buy

Code written for MySQL Connector/Python or PyMySQL uses %s placeholders, while Devart's examples use ?, and the connection parameters are named differently (Server, UserId). Moving an existing project over takes some edits. The subscription license also checks its status online, so a server without internet access needs the perpetual license.

Where it falls short

  • Not open source. You can't read or patch the code, and the license rules out redistributing it except under an OEM license.
  • Linux is 64-bit x86 only. The wheels cover manylinux x86_64; there's no ARM Linux build listed.
  • Per-developer licensing. A Single license is for one user; a team of up to four needs the Team license.
  • No ORM layer. It's a DB API driver only; mapping rows to objects is up to your code or framework.

Comparisons

Devart vs. free MySQL drivers for Python

Oracle's MySQL Connector/Python and PyMySQL are free, open source and widely used, and are the natural default. Devart Python Connector for MySQL costs $74.95 a year but adds built-in SSH and HTTP tunnelling, MySQL versions back to 3.23, MariaDB-specific types, tunable pooling and vendor support. Pay for it when one of those solves a real problem for you.

Python connector vs. Devart's ODBC driver for MySQL

Devart also sells MySQL connectivity as an ODBC driver, which serves Excel, Power BI and any ODBC tool. At $139.95 a year for a desktop, the ODBC driver costs more; if your only consumer is Python code, this $74.95 module is the lighter and cheaper choice; if reports and Python both need MySQL, the ODBC driver serves both.

Editions and Pricing

License1-year subscriptionPerpetualWho can use it
Single$74.95$149.95One developer at one company site
TeamOn the order pageOn the order pageUp to 4 developers at one company site
SiteOn the order pageOn the order pageUnlimited developers at one company site

Buy Now opens the order with a Single license on a 1-year subscription; Team, Site, the perpetual license and 2- or 3-year terms are selected on the order page. An OEM license for shipping the connector inside your own product is arranged with Devart separately.

FAQs

Can I use Devart's Python connector with Amazon Aurora or Azure?

Yes. Devart Python Connector for MySQL lists Amazon Aurora, Amazon RDS for MySQL, Azure Database for MySQL and Google Cloud for MySQL among its supported servers.

Does the Devart MySQL connector work with Python 3.9?

No. Devart Python Connector for MySQL 1.4 supports Python 3.10 to 3.15; support for 3.7, 3.8 and 3.9 was removed in that release.

Can I ship the Devart connector inside an application I sell?

Only with an OEM license. Devart Python Connector for MySQL's Single, Team and Site licenses allow developing and deploying your own scripts and applications within one company; redistributing the connector itself, or building public Python packages on it, isn't allowed without OEM terms.

Does the subscription keep working offline?

No. Devart Python Connector for MySQL's subscription license needs an internet connection to activate and to check its status, and stops being usable when the term ends. The perpetual license runs a specific version without a subscription.

Can I get a refund on Devart Python Connector for MySQL?

Possibly. Devart Python Connector for MySQL's order page offers a 30-day money-back guarantee if you're not satisfied, but Devart's ordering FAQ describes refunds within 30 days only for technical problems its support can't fix. Use the 30-day trial to be sure before you buy.

Does it support MariaDB as well as MySQL?

Yes. Devart Python Connector for MySQL supports MariaDB 5.x to 12.x, including MariaDB's UUID type from 10.7 and INET4 and INET6 types from 10.10.

System Requirements

  • Python 3.10, 3.11, 3.12, 3.13, 3.14 or 3.15 with pip
  • Windows 32-bit or 64-bit, Windows Server, macOS (Intel or Apple silicon) or 64-bit Linux
  • MySQL 3.23 to 9.7 or MariaDB 5.x to 12.x, local or cloud-hosted
  • Internet access for activating and checking a subscription license

Conclusion

Devart Python Connector for MySQL is worth $74.95 a year to a company that needs something the free drivers make hard: tunnelled connections without extra tooling, Kerberos sign-on, very old or very new MySQL and MariaDB versions, or a supported commercial component. For an ordinary app talking to a modern MySQL server, the free MySQL Connector/Python or PyMySQL will do, and the closed license rules it out for open-source work. If one of its extras fits your setup, test it with the trial against your own server.

Download Free Trial Buy Now

Submit Your Review
Your Name:
Rating:
(Please click on one of the stars to indicate your rating.)
One Line Summary:
Review:
No html tags are allowed.
Submit Review
We may earn a commission when you buy through links on this page.

Related Videos
Easy MySQL Connection in Python Without Client Libraries Using Devart
Easy MySQL Connection in Python Without Client Libraries Using Devart

Video Length: 04:00
Uploaded By: 0xSECRETenv (10/4/2024)
View Count: 118

Copyright © 2026, Ivertech. All rights reserved.