mysqlsh --uri xdev_full_user:SecurePass123!@localhost:33060 Inside the shell, test full capabilities:
| Alternative | Description | When to Use | |-------------|-------------|--------------| | xdevaccess yes read-only | Allows only SELECT operations and document retrieval. | Analytics dashboards, reporting tools. | | xdevaccess yes limited | Grants access to a single schema or collection. | Microservices with bounded contexts. | | xdevaccess yes with quotas | Limits rows returned or operations per minute. | Multi-tenant applications. | | Traditional SQL over TCP (port 3306) | Standard MySQL protocol without X DevAPI features. | Legacy apps that don't need NoSQL collections. | Scenario : A quantitative finance firm needed to run backtesting simulations that required creating and dropping thousands of document collections per hour. Using standard SQL caused excessive overhead. xdevaccess yes full
sudo ufw allow 33060/tcp Use the MySQL Shell in X DevAPI mode: mysqlsh --uri xdev_full_user:SecurePass123