Installing phpMyAdmin

To install phpMyAdmin:

1. Create a new static/cgi/php application and connect it to a website.
2. SSH into your server and run the following commands to download and extract PMA:

   cd ~
   wget http://downloads.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.5.2.2/phpMyAdmin-3.5.2.2-english.tar.bz2?r=http%3A%2F%2Fwww.phpmyadmin.net%2Fhome_page%2Fdownloads.php&ts=1348609141&use_mirror=freefr"
   cd ~/webapps/name_of_app
   tar jxf ~/phpMyAdmin-3.5.2.2-english.tar.bz2 --strip 1
   mkdir config
   

3. Go to http://url_of_the_site/setup/ in your browser.
4. Click "New server".
5. Enter a friendly name for the new server.
6. Enter localhost as the server hostname.
7. Enter your MySQL app's assigned port.
8. Enter the full path to your MySQL app's socket.
9. Check Use SSL if you're accessing the site via HTTPS.
10. Select socket as the connection type.
11. Click Save to save the server.
12. Under Configuration file, click Save to save your config.
13. Back in your SSH session, run the following commands:

    cd ~/webapps/name_of_app
    mv config/config.inc.php ./
    rm -rf config
    echo "deny from all" > setup/.htaccess

At that point, phpMyAdmin should be available at the site you created in the first step.

Database management at the command line is done with the normal MySQL command line utilities, using options to point them at your private MySQL. For example, to create a database named "my_db":

1

mysqladmin -S ~/webapps/ms/var/mysql.sock -u root -p create my_db

Your can run "mysqladmin --help" and "man mysqladmin" in a SSH session for more information, or consult the MySQL documentation.

Hope that helps!