PHPMyAdmin

PHPMyAdmin for SME Server

	Skill level: Medium
	The instructions on this page require a basic knowledge of linux.

	Warning:
	ONLY run this contribs on SME 8, if you use the current updated version : including smeserver-phpmyadmin-3.5.2.2-1.el5.sme and phpMyAdmin3-3.5.2.2-1.el5 or newer. phpmyadmin 2 will corrupt your data if you intent to use it with SME8 as it uses php 5.3 ---Unnilennium 13:32, 24 September 2012 (MDT)

phpmyadmin

description

Contrib 10:

4.0.10.2-14

Contrib 9:

4.0.10.2-3

smeserver-phpmyadmin

description

Maintainer

Darrell 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 smecontribs repository. To install this contrib you will have to get shell access as root user, and issue the following command:

yum --enablerepo=smecontribs install smeserver-phpmyadmin

and either

signal-event post-upgrade; signal-event reboot

or

for SME 7

expand-template /usr/share/phpmyadmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
/usr/local/bin/svc -h /service/httpd-e-smith

for SME 8

expand-template /etc/phpMyAdmin/config.inc.php
expand-template /etc/httpd/conf/httpd.conf
/usr/local/bin/svc -h /service/httpd-e-smith

	Note:
	if you need to install php-mcrypt this is the workaround

yum --enablerepo=smecontribs install php-mcrypt
signal-event post-upgrade; signal-event reboot

Uninstall

rpm -e smeserver-phpmyadmin 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 SME Server shell.

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

	Warning:
	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

• Access with admin username/password via: https://yourdomain/phpmyadmin

• 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 .

---