Difference between revisions of "Phpmyadminmulti"

From SME Server
Jump to navigationJump to search
(11 intermediate revisions by 8 users not shown)
Line 1: Line 1:
 
{{Languages|Phpmyadminmulti}}
 
{{Languages|Phpmyadminmulti}}
==Maintainer==
 
[[User:MasterSleepy|Michel Van hees]]<br/>
 
 
==Description==
 
Automatic installation of [http://www.phpmyadmin.net PHPMyAdmin] on SME Server.
 
 
[http://www.phpmyadmin.net PHPMyAdmin] can handle all MySQL database that are on SME Server.
 
  
 
==Installation==
 
==Installation==
  
wget <nowiki>"http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296"</nowiki>
+
Since SME8 you can use the smeserver-phpmyadmin contrib to have a mysql user based access. As a result smeserver-phpmyadminmulti is deprecated. Thank you to [[User:MasterSleepy|Michel Van hees]] for its initial idea in creating this contrib.
yum localinstall smeserver-phpmyadmin-multiuser-2.11.1-1.noarch.rpm
 
 
 
==Deinstallation==
 
 
 
yum remove 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
 
 
 
  
==Additional information==
+
information : [[PHPMyAdmin]]
*[http://www.phpmyadmin.net PHPMyAdmin website]
 
 
----
 
----
 
[[Category: Contrib]]
 
[[Category: Contrib]]
 
[[Category: Administration]]
 
[[Category: Administration]]

Revision as of 18:58, 22 June 2013


Installation

Since SME8 you can use the smeserver-phpmyadmin contrib to have a mysql user based access. As a result smeserver-phpmyadminmulti is deprecated. Thank you to Michel Van hees for its initial idea in creating this contrib.

information : PHPMyAdmin