Phpmyadmin: Difference between revisions

Revision as of 15:14, 9 September 2008

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 on your LinuxMCE 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).

@@ Line 1: / Line 1: @@
-=Installing phpMyAdmin on your LinuxMCE Core=
+[[Category: Tutorials]]
-===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.===
+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 on your LinuxMCE system=
+==Installing on your LinuxMCE system==
 *Open a shell on the core.
-*You will need to run as root to do this, so type
+*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.
+*Once it is completed installing, you will need to create a symlink to access it.  Do this by typing:
-*Do this by typing
    sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin
-'''This creates your simlink and your on your way!'''
+==Using phpMyAdmin==
-[[Category: Tutorials]]
+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).