| Line 1: |
Line 1: |
| | {{Languages|Phpmyadminmulti}} | | {{Languages|Phpmyadminmulti}} |
| − | =phpmyadmin-multiuser for SME 7.x=
| |
| − |
| |
| − | ==Mainteneur==
| |
| − | [[User:MasterSleepy|Michel Van hees]]<br/>
| |
| − |
| |
| − | ==Description==
| |
| − | Automatic installation of [[http://www.phpmyadmin.net phpmyadmin]] on SmeServer.
| |
| − |
| |
| − | [[http://www.phpmyadmin.net phpmyadmin]] can handle all MySQL database that are on SmeServer.
| |
| − |
| |
| | | | |
| | ==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.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==
| |
| − | *[http://www.phpmyadmin.net Site web]
| |
| − | | |
| − | ''Michel Van hees (MasterSleepy)''
| |
| | | | |
| | + | information : [[PHPMyAdmin]] |
| | ---- | | ---- |
| | [[Category: Contrib]] | | [[Category: Contrib]] |
| | + | [[Category: Administration]] |
