{"library":"mysql-connector-python-rf","title":"MySQL Connector/Python (RF variant)","description":"An old, unmaintained variant of the pure Python MySQL driver for Python, implementing the DB API v2.0 specification (PEP-249). This package was released to PyPI to address distribution issues with the official 'mysql-connector-python' around 2015-2017. It is currently at version 2.2.2 and has not been updated since February 2017.","language":"python","status":"abandoned","last_verified":"Mon May 18","install":{"commands":["pip install mysql-connector-python-rf"],"cli":null},"imports":["import mysql.connector","from mysql.connector import MySQLConnection"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import mysql.connector\nimport os\n\nhost = os.environ.get('MYSQL_HOST', 'localhost')\nuser = os.environ.get('MYSQL_USER', 'your_user')\npassword = os.environ.get('MYSQL_PASSWORD', 'your_password')\ndatabase = os.environ.get('MYSQL_DATABASE', 'test_db')\n\ntry:\n    # Establish a connection\n    cnx = mysql.connector.connect(\n        host=host,\n        user=user,\n        password=password,\n        database=database\n    )\n\n    if cnx.is_connected():\n        print(\"Successfully connected to MySQL database.\")\n\n        cursor = cnx.cursor()\n        # Create a table (if it doesn't exist)\n        cursor.execute(\"CREATE TABLE IF NOT EXISTS users (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), email VARCHAR(255))\")\n        cnx.commit()\n        print(\"Table 'users' ensured to exist.\")\n\n        # Insert data\n        add_user = (\"INSERT INTO users (name, email) VALUES (%s, %s)\")\n        data_user = (\"John Doe\", \"john.doe@example.com\")\n        cursor.execute(add_user, data_user)\n        cnx.commit()\n        print(\"Data inserted.\")\n\n        # Query data\n        cursor.execute(\"SELECT id, name, email FROM users\")\n        for (id, name, email) in cursor:\n            print(f\"ID: {id}, Name: {name}, Email: {email}\")\n\n    else:\n        print(\"Failed to connect to MySQL database.\")\n\nexcept mysql.connector.Error as err:\n    print(f\"Error: {err}\")\n\nfinally:\n    if 'cnx' in locals() and cnx.is_connected():\n        cursor.close()\n        cnx.close()\n        print(\"MySQL connection closed.\")","lang":"python","description":"This quickstart demonstrates how to connect to a MySQL database, create a table, insert data, and query data using the `mysql.connector` module. It follows the standard Python DB-API 2.0 pattern and includes basic error handling and proper resource cleanup.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":{"tag":null,"tag_description":null,"last_tested":"2026-05-18","installed_version":"2.2.2","pypi_latest":"2.2.2","is_stale":false,"summary":{"python_range":"3.10–3.9","success_rate":100,"avg_install_s":3,"avg_import_s":0.06,"wheel_type":"sdist"},"results":[{"runtime":"python:3.10-alpine","python_version":"3.10","os_libc":"alpine (musl)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.06,"mem_mb":2.5,"disk_size":"21.1M"},{"runtime":"python:3.10-slim","python_version":"3.10","os_libc":"slim (glibc)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":2.4,"import_time_s":0.04,"mem_mb":2.5,"disk_size":"22M"},{"runtime":"python:3.11-alpine","python_version":"3.11","os_libc":"alpine (musl)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.07,"mem_mb":2.7,"disk_size":"23.8M"},{"runtime":"python:3.11-slim","python_version":"3.11","os_libc":"slim (glibc)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":2.5,"import_time_s":0.07,"mem_mb":2.7,"disk_size":"24M"},{"runtime":"python:3.12-alpine","python_version":"3.12","os_libc":"alpine (musl)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.06,"mem_mb":2.6,"disk_size":"13.7M"},{"runtime":"python:3.12-slim","python_version":"3.12","os_libc":"slim (glibc)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":3.6,"import_time_s":0.07,"mem_mb":2.6,"disk_size":"14M"},{"runtime":"python:3.13-alpine","python_version":"3.13","os_libc":"alpine (musl)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.06,"mem_mb":2.7,"disk_size":"13.5M"},{"runtime":"python:3.13-slim","python_version":"3.13","os_libc":"slim (glibc)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":3.4,"import_time_s":0.06,"mem_mb":2.5,"disk_size":"14M"},{"runtime":"python:3.9-alpine","python_version":"3.9","os_libc":"alpine (musl)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":null,"import_time_s":0.05,"mem_mb":2.5,"disk_size":"20.7M"},{"runtime":"python:3.9-slim","python_version":"3.9","os_libc":"slim (glibc)","variant":"mysql-connector-python-rf","exit_code":0,"wheel_type":"sdist","failure_reason":null,"import_side_effects":"clean","install_time_s":2.9,"import_time_s":0.05,"mem_mb":2.5,"disk_size":"21M"}]}}