Supported MySQL Versions

Overview

DBWillow supports multiple MySQL and MariaDB versions, with optimized drivers for each.

Supported Versions

MySQL

MySQL 5.7+ - Full support
MySQL 8.0+ - Full support with optimizations
MySQL 8.1+ - Latest features supported

MariaDB

MariaDB 10.0+ - Full support
MariaDB 10.1+ - Full support
MariaDB 10.2+ - Full support
MariaDB 10.3+ - Full support
MariaDB 10.4+ - Full support
MariaDB 10.5+ - Full support
MariaDB 10.6+ - Full support
MariaDB 10.7+ - Full support
MariaDB 10.8+ - Full support
MariaDB 10.9+ - Full support
MariaDB 10.10+ - Full support
MariaDB 10.11+ - Full support
MariaDB 11.0+ - Full support

Driver Selection

Automatic Detection

DBWillow automatically detects your database version and selects the appropriate driver:

MySQL 8.0+ → MySQL 8.0 Driver
MySQL 5.7 → MySQL Driver
MariaDB → MariaDB Driver

Manual Selection

You can manually select a driver:

Open connection settings
Go to Advanced options
Select driver type
Save connection

Feature Compatibility

MySQL 8.0+ Features

Window functions
Common Table Expressions (CTEs)
JSON functions
Role-based access control
Improved performance

MariaDB Features

ColumnStore
Galera Cluster
Dynamic columns
Virtual columns
Sequence storage engines

Recommendations

For New Projects

Use MySQL 8.0+ or MariaDB 10.5+
Take advantage of latest features
Better performance
Enhanced security

For Existing Projects

DBWillow works with older versions
Test compatibility
Consider upgrading
Check feature support

Troubleshooting

Connection Issues

Verify version compatibility
Check driver selection
Review error messages
Test with command line

Feature Not Working

Check version support
Verify driver selection
Review documentation
Check MySQL/MariaDB docs

Next Steps