Phpmyadminmulti

Languages:

English  • français

	Not reviewed:
	This howto or contrib has not been reviewed and might contain code that could harm your installation. For more information on the review process have a look at the Development Review page.

Maintainer

Michel Van hees

Description

Automatic installation of PHPMyAdmin on SME Server.

PHPMyAdmin can handle all MySQL database that are on SME Server.

Version

Current version : 2.11.9

Installation

wget "http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296"
yum localinstall smeserver-phpmyadmin-multiuser-*.noarch.rpm

	Warning:
	this contrib is no longer supported since SME Server 8.0, if you want to have the phpmyadminmulti, you must install the contrib PHPMyAdmin and activate the option multiaccess

Uninstallation

yum remove smeserver-phpmyadmin-multiuser

Use

You can access phpmyadmin interface by opening your web browser at the address:

https://[IP or DOMAIN]/myadmin

A login and a password is needed to connect. By default, the installation process creates a user "admin" with "admin" as password.

Of course, the first thing you have to do, is change the admin password.

Use the following commands (replace newpassword with your actual desired admin password).

You can also use the same commands to reset the admin password to admin, if you have any problems connecting (ie replace newpassword with the word admin). You must be logged in as the root user.

mysql --execute="grant all privileges on *.* to admin@localhost identified by 'newpassword' WITH GRANT OPTION"
mysql --execute="flush privileges"

Settings

By default, installation process limit access at phpmyadmin to local network.

To enable phpmyadmin to be access from internet and local network :

db configuration setprop phpmyadminmulti access public
signal-event console-save

To limit access to local network :

db configuration setprop phpmyadminmulti access private
signal-event console-save

Additional information

• PHPMyAdmin website

---