Difference between revisions of "Phpmyadmin"
(added hint on usage + a little cleanup) |
Langstonius (Talk | contribs) |
||
| Line 1: | Line 1: | ||
[[Category: Tutorials]] | [[Category: Tutorials]] | ||
| + | =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. | 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 | + | ==Installing and 0810 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: | ||
| Line 10: | Line 11: | ||
sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin | sudo ln -s /usr/share/phpmyadmin /var/www/phpmyadmin | ||
| − | ==Using phpMyAdmin== | + | ===Using phpMyAdmin=== |
After creating the symlink, you can now access phpmyadmin similar to the pluto web-admin, by pointing your browser to: | After creating the symlink, you can now access phpmyadmin similar to the pluto web-admin, by pointing your browser to: | ||
http://dcerouter/phpmyadmin/ | 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). | 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, then you will need to create a new user and password. This way, you do not interfere with the root users privileges and you provide security | ||
Revision as of 22:01, 24 March 2011
Contents
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, then you will need to create a new user and password. This way, you do not interfere with the root users privileges and you provide security
