Revision as of 21:04, 24 March 2011

Overview

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

Installing and 0810 System

• Open a shell on the core.
• You will need to run as root to do this, so type:

 sudo apt-get install phpmyadmin

• Once it is completed installing, you will need to create a symlink to access it. Do this by typing:

 sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

Using phpMyAdmin

After creating the symlink, you can now access phpmyadmin similar to the pluto web-admin, by pointing your browser to:

http://dcerouter/phpmyadmin/

If the name dcerouter is unknown, try replacing it with your core's IP address (usually 192.168.80.1 if you're on the internal network).

Installing on 10.04

The installation process on 10.04 is essentially the same with some minor configuration changes to allow it to run. Please pay attention to your options here.

• Open a shell on the core.
• You will need to run as root to do this, so type:

 sudo apt-get install phpmyadmin

• Once it is completed installing, you will need to create a symlink to access it. Do this by typing:

 sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin

Using phpMyAdmin

To use the software, you will need to do one of two things.

If your core is accessible to the world:

• Set a password for the root user OR
• Create a new user and set a password

If your core is not publicly accessible:

• You will need to edit /etc/phpmyadmin/config.inc.php
• Edit the file /etc/phpmyadmin/config.inc.php, search and uncomment (remove the '//' before it) this line:

// $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

You can now access phpmyadmin.