Difference between revisions of "Phpmyadmin"

From LinuxMCE
Jump to: navigation, search
(added hint on usage + a little cleanup)
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.  
 
*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
 
   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
 
   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).

Revision as of 16: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).