We removed our free Sandbox April 25th.
You can read more on our blog.
Adding phpMyAdmin to your existing project is easy! It can accomplished with the following steps:
Start in the directory containing your application.
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
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
$ dotcloud push -A <application>
Get the url for your phpmyadmin interface:
$ dotcloud domain list pma: myapp-myusername.dotcloud.com
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
Open the pma URL in your browser and enter the LOGIN and PASSWORD.
Now you’re ready to manage your MySQL databases with PHPMyAdmin.
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.
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.