MySQL Connector
MySQL has its own quirks around database names, case sensitivity, and password masking — this guide covers exactly what Mobio expects for each field.
1. Overview
- Definition: Covers the network settings and validation rules required to connect Mobio to a MySQL database.
- Users: System Admin, Data Engineer.
2. Terminology & Configuration Parameters
- MySQL — A relational database management system.
- Standard port — 3306.
3. Prerequisites
- Related article: Create Connector: Database
4. Configuration Limits by Field
Follow these rules exactly for a successful connection:
- Database Name — Up to 64 characters. Spaces are allowed, but if you use one, wrap the name in backticks (e.g.,
`DB Sales`). Case-sensitive: enter the exact case (e.g.,DB01anddb01are different if your MySQL server runs on Linux with case sensitivity enabled). - Hostname/IP — Up to 253 characters. Accepts IPv4 or an FQDN (domain name). No
http://prefix or trailing slash/. Remove any leading/trailing spaces (Mobio trims them). - Port — 1–65535 (up to 5 digits). The default port is 3306. No commas or spaces.
- Username — Up to 32 characters. Spaces are allowed, but Mobio doesn’t auto-trim them — enter this carefully. Never use control characters or slashes (
\,/). - Password — No length limit. Mobio allows spaces, but avoid characters that can break the DB driver (like single quotes
', double quotes", or--).
5. Operational Rules
- MySQL permissions required: From the command line, run
mysqladmin ping -h <hostname> -P 3306to check availability. Mobio’s account only needs SELECT permission.
6. Frequently Asked Questions (FAQ)
- Q: No matter how long my password is, why does Mobio’s interface show it so short?
- A: Once saved, Mobio encrypts your password and always displays it as a fixed 15-character string of
*****for security.
- A: Once saved, Mobio encrypts your password and always displays it as a fixed 15-character string of
7. Next Steps
Back to Create Connector: Database