Difference between revisions of "Phpmyadminmulti"

From SME Server
Jump to navigationJump to search
Line 35: Line 35:
 
  mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
 
  mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
 
  mysql --execute="flush privileges"
 
  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
  
  

Revision as of 07:47, 19 June 2007


phpmyadmin-multiuser for SME 7.x

Mainteneur

Michel Van hees

Description

Automatic installation of [phpmyadmin] on SmeServer.

[phpmyadmin] can handle all MySQL database that are on SmeServer.


Installation

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


Désinstallation

rpm -e smeserver-phpmyadmin-multiuser


Utilisation

You can access phpmyadmin interface by opening your web browser at the address: https://[IP ou NOM]/myadmin

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

Of course, the first thing you have to do, is to change it

If you have any problem to connect, launch both command at command line as root user:

mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' 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


Informations additionnelles

Michel Van hees (MasterSleepy)