We removed our free Sandbox April 25th.
You can read more on our blog.

phpMyAdmin

Adding phpMyAdmin to your existing project is easy! It can accomplished with the following steps:

  1. Start in the directory containing your application.

  2. Clone into the repo into your project structure, followed by removing the .git repository directory.:

    $ git clone https://github.com/dotcloud/phpmyadmin-on-dotcloud phpmyadmin
    $ rm -rf phpmyadmin/.git
  3. Edit the dotcloud.yml file to add the http interface.:

    db:                    # Your existing database
      type: mysql
    
    # Add This...........................................
    # New service, can be any name, but type must be php.
    # approot should be phpmyadmin since that is where
    # you put the github code in the clone step.
    pma:                   # <-- new service
      type: php            # <-- new type
      approot: phpmyadmin  # <-- new subdir of code
  4. dotcloud push!:

    $ dotcloud push -A <application>
  5. Get the url for your phpmyadmin interface:

    $ dotcloud domain list
    pma: myapp-myusername.dotcloud.com
  6. Get the username and password you’ll need for phpmyadmin:

    $ dotcloud env list | grep MYSQL_LOGIN
    ==> Environment variables for application myapp
    DOTCLOUD_DB_MYSQL_LOGIN=root
    
    $ dotcloud env list | grep MYSQL_PASSWORD
    ==> Environment variables for application myapp
    DOTCLOUD_DB_MYSQL_PASSWORD=something secret
  7. Open the pma URL in your browser and enter the LOGIN and PASSWORD.

Now you’re ready to manage your MySQL databases with PHPMyAdmin.

Note

The phpmyadmin recipe finds the mysql databases that are located within the environment.json file. No additional web configuration is required. Basically, each mysql database in your dotcloud.yml file will be picked up by the phpMyAdmin recipe dynamically.

Note

Using the phpMyAdmin is out of scope for this example as it assumes you already know how to use it. There’s a few tutorials which can be found with a quick google search, one such can be found here.