Difference between revisions of "Phpmyadmin"
Langstonius (Talk | contribs) (→Using phpMyAdmin) |
Langstonius (Talk | contribs) (→Using phpMyAdmin) |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 4: | Line 4: | ||
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 on an 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 29: | Line 29: | ||
If your core is accessible to the world: | If your core is accessible to the world: | ||
| − | + | Im not sure what to do. i tried setting a pass and it borked my system. | |
| − | + | ||
If your core is not publicly accessible: | If your core is not publicly accessible: | ||
Latest revision as of 17:26, 5 June 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 on an 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: Im not sure what to do. i tried setting a pass and it borked my system.
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.
