|
|
| (One intermediate revision by the same user not shown) |
| Line 1: |
Line 1: |
| | {{Languages|Phpmyadminmulti}} | | {{Languages|Phpmyadminmulti}} |
| − | {{Needs review}}
| |
| − | ==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.
| |
| − | ==Version==
| |
| − | Current version : 2.11.9
| |
| | | | |
| | ==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-*.noarch.rpm
| |
| − | {{warning box|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 [[PHPMyAdmin#multiaccess|multiaccess]]}}
| |
| − | | |
| − | ==Uninstallation==
| |
| − | | |
| − | yum remove smeserver-phpmyadmin-multiuser
| |
| − | | |
| − | ==Use==
| |
| − | You can access phpmyadmin interface by opening your web browser at the address:
| |
| − | <pre>https://[IP or DOMAIN]/myadmin</pre>
| |
| − | | |
| − | 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==
| + | information : [[PHPMyAdmin]] |
| − | *[http://www.phpmyadmin.net PHPMyAdmin website]
| |
| | ---- | | ---- |
| | [[Category: Contrib]] | | [[Category: Contrib]] |
| | [[Category: Administration]] | | [[Category: Administration]] |
