MySQL connection details/credentials for ClearDB on AppFog

AppFog offers ClearDB as a simple-to-install plugin. One click in the AppFog admin interface creates a “aluminium” account at AppFog and sets up the database.

The connection details are made available to your app in the CLEARDB_DATABASE_URL env variable.

It is also possible to use a MySQL client (e.g. the mysql CLI, or Sequel Pro on OS X) to connect directly to ClearDB. All the required info is available in the Env Variables tab on the AppFog dashboard, where the CLEARDB_DATABASE_URL variable is listed. It has the following format:

mysql://[user]:[pwd]@[host]/[db]