PhloemDocs
Markdown
Integration

MySQL

Open-source relational database

Category
Databases
Runs in
The Phloem cloud — nothing to install

Lets you and Hamming query a MySQL database with SQL, with its tables listed in Trace.

What Phloem reads

  • Tables, columns and foreign keys of the database you name, listed in Trace for Hamming and SQL autocomplete
  • Base tables only. Views are not listed, but you can still query them by name.

What you need

  • The server's host and port (default 3306), reachable from Phloem's cloud
  • The database name
  • A username and password. Best: a user with SELECT only on that database.

Connect

  1. In the console, open Connectors, choose Add connector, then MySQL.
  2. Enter a Display Name, then Host, Port, Database, Username and Password.
  3. Choose Test Connection (it shows the server version), then Create Connection.

What Hamming can do

  • Run SQL that you or Hamming write

Notes

  • Phloem runs any statement, not only SELECT, and each one commits as it runs. The user's privileges decide what a query can change.
  • One connector reads one database. Add another connector for a second database.

#Connection fields

What the Add connector form asks for.

FieldTypeRequired
Host
localhost
TextYes
Port
3306
Number—
Database
mydb
TextYes
Username
root
Text—
PasswordSecret—

Updated