SQLPro for MySQL Blog
Tips, tutorials, and updates for MySQL and MariaDB.
Microsoft Entra ID (MFA) sign-in for Azure SQL on Mac, iPhone and iPad
Posted by Kyle Hankinson
Connect to Azure SQL Database and Managed Instance with your Microsoft Entra ID account, multi-factor authentication included, on macOS, iPhone and iPad.
SQLPro Studio is now available on Android
Posted by Kyle Hankinson
The native database client for macOS, iOS and Windows is now on Google Play for Android phones and tablets, along with the MySQL and SQL Server apps.
SQLPro Keyboard Shortcuts
Posted by Kyle Hankinson
The full list of default keyboard shortcuts in SQLPro for MySQL on macOS and Windows, which actions ship unassigned, and how to rebind any of them from Preferences.
SSH Tunnels for Remote Database Access: ssh -L, Explained
Posted by Kyle Hankinson
How SSH local port forwarding gets you into a firewalled database. Real tunnel demo, the MySQL localhost gotcha, per-engine notes, and tunnel errors decoded.
Fixing MySQL "Incorrect string value": utf8 vs utf8mb4 Done Right
Posted by Kyle Hankinson
MySQL rejects emoji with error 1366 because utf8 is really the 3-byte utf8mb3. How to safely convert to utf8mb4 across every layer without breaking indexes.