Difference between revisions of "PHPMyAdmin"
m (Minor text changes and added a warning) |
|||
| Line 23: | Line 23: | ||
=== Configuration === | === Configuration === | ||
By default, access to phpmyadmin is restricted to the local network, and to any trusted networks. To make phpmyadmin accessible to external networks (the internet), the configuration parameter for access has to be changed. Changing this parameter requires you to use the Linux command line. | By default, access to phpmyadmin is restricted to the local network, and to any trusted networks. To make phpmyadmin accessible to external networks (the internet), the configuration parameter for access has to be changed. Changing this parameter requires you to use the Linux command line. | ||
| − | + | ||
| − | + | To view the current access setting: | |
| − | + | ||
| + | db configuration show phpmyadmin | ||
| + | |||
| + | This would output something like this: | ||
phpmyadmin=configuration | phpmyadmin=configuration | ||
| − | + | access=private | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | To change the current setting: | |
| − | + | db configuration setprop phpmyadmin access (private|public) | |
| − | + | signal-event ibay-modify | |
| + | {{Warning box|Setting the access type to public makes PHPMyAdmin available to the internet, make sure you choose a strong password before doing so as you severely weaken the security of your server.}} | ||
=== Additional information === | === Additional information === | ||
Revision as of 07:26, 22 April 2008
PHPMyAdmin for SME Server
Maintainer
Darell May
Description
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, manage privileges,export data into various formats.
This contrib provides PHPMyAdmin for SME Server.
Installation
This contrib can be found in the Darrell's contrib directory . To install this contrib you will have to get shell access as root user, download the contrib and issue the following command:
yum localinstall /path/to/smeserver-phpmyadmin*.rpm
Check installed version
yum info installed smeserver-phpmyadmin
Uninstall
yum remove smeserver-phpmyadmin
Configuration
By default, access to phpmyadmin is restricted to the local network, and to any trusted networks. To make phpmyadmin accessible to external networks (the internet), the configuration parameter for access has to be changed. Changing this parameter requires you to use the Linux command line.
To view the current access setting:
db configuration show phpmyadmin
This would output something like this:
phpmyadmin=configuration access=private
To change the current setting:
db configuration setprop phpmyadmin access (private|public) signal-event ibay-modify
Additional information
- To access PHPMyadmin, go to your-domain/phpmyadmin
- The initial login and password for phpmyadmin is login="admin" & password="admin"
- The password is changed using the privileges section of phpmyadmin. (Locate the admin user and assign a new password there).
More information about PhpMyAdmin can be found on the PHPMyAdmin site.
Bugs
Please raise bugs under the SME-Contribs section in bugzilla and select the smeserver-phpmyadmin component or use this link .
