Difference between revisions of "Phpmyadminmulti"
MasterSleepy (talk | contribs) |
RayMitchell (talk | contribs) (clarified login domain & admin password commands & text) |
||
| Line 21: | Line 21: | ||
==Utilisation== | ==Utilisation== | ||
You can access phpmyadmin interface by opening your web browser at the address: | You can access phpmyadmin interface by opening your web browser at the address: | ||
| − | https://[IP | + | https://[IP or DOMAIN]/myadmin |
A login and a password is needed to connect. | A login and a password is needed to connect. | ||
| − | By default, installation process | + | By default, the installation process creates a user "admin" with "admin" as password. |
| − | '''Of course, the first thing you have to do, is | + | '''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). | |
| − | mysql --execute="grant all privileges on *.* to admin@localhost identified by ' | + | 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" | mysql --execute="flush privileges" | ||
Revision as of 07:44, 31 December 2007
Maintainer
Description
Automatic installation of PHPMyAdmin on SME Server.
PHPMyAdmin can handle all MySQL database that are on SME Server.
Version
Current version : 2.11.3
Installation
wget "http://www.vanhees.cc/index.php?name=CmodsDownload&file=index&req=getit&lid=296" yum localinstall smeserver-phpmyadmin-multiuser-*.noarch.rpm
Deinstallation
yum remove smeserver-phpmyadmin-multiuser
Utilisation
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
