MySQL is a popular open-source relational database.
Installation
Required packages: mysqlclient
Drivers
mysqlclientRecommended
mysql-connector-python
PyPI Package:
mysqlclientmysql://{username}:{password}@{host}/{database}Recommended driver. May fail with caching_sha2_password auth.
Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 59/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Troubleshooting
Common error messages you may encounter when connecting to or querying MySQL, along with their causes and solutions.
Compatible Databases
The following databases are compatible with the MySQL driver:
MariaDBMariaDB is a community-developed fork of MySQL, fully compatible with MySQL.
mysql://{username}:{password}@{host}:{port}/{database}
Amazon Aurora MySQLAmazon Aurora MySQL is a fully managed, MySQL-compatible relational database with up to 5x the throughput of standard MySQL.
mysql+auroradataapi://{aws_access_id}:{aws_secret_access_key}@/{database_name}?aurora_cluster_arn={aurora_cluster_arn}&secret_arn={secret_arn}®ion_name={region_name}Parameters:
| Parameter | Description |
|---|---|
| aws_access_id | AWS Access Key ID |
| aws_secret_access_key | AWS Secret Access Key |
| database_name | Database name |
| aurora_cluster_arn | Aurora cluster ARN |
| secret_arn | Secrets Manager ARN for credentials |
| region_name | AWS region (e.g., us-east-1) |
Uses the Data API for serverless access. Standard MySQL connections also work with mysqlclient.