Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: wellsi on July 18, 2004, 05:54:42 PM

Title: Contrib Feedback: phpMyAdmin
Post by: wellsi on July 18, 2004, 05:54:42 PM

phpMyAdmin

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields.

Author(s): Thor Anthrax (nightspirit)
Contributor(s):
License: Unknown

How To Link: http://no.longer.valid/phpwiki/index.php/phpMyAdmin
Topic Page: MySQL (http://no.longer.valid/phpwiki/index.php/MySQL)

This thread is for feedback specificaly related to this How To & Contrib.
Reports of success are welcome, as well as any problems and suggested improvements.

Title: Contrib Feedback: phpMyAdmin
Post by: wellsi on July 18, 2004, 05:55:31 PM

Updated 13th July: STABLE = 2.5.7, Beta = 2.6

Title: Granular access rights to the database
Post by: larsk on September 11, 2004, 03:35:58 PM

* If you wish to enable local network access, you can do so via:
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
service mysqld restart

This will enable port 3306

* If you wish to have developers access your database:
1. Create an extra account e.q. [dba] with all priviliges for admin usage
2. Create a control useraccount [pma] and give select rights to mysql.users and so on:
    For 'HTTP' and 'cookie' modes, phpMyAdmin needs a controluser that has only the SELECT privilege on the mysql.user (all columns except "Password"), mysql.db (all columns) & mysql.tables_priv (all columns except "Grantor" & "Timestamp") tables.
    You must specify the details for the controluser in the config.inc.php file under the $cfg['Servers'][$i]['controluser']& $cfg['Servers'][$i]['controlpass'] settings.

2. Change config.inc.php in /etc/e-smith/templates/opt/administration/phpmyadmin
- set auth_type to http
- set the user to ''
- set the password to ''
- fill in the created controluser and password

3. Change httpd.conf in /etc/e-smith/templates/etc/httpd/conf/httpd.conf/ the file 86PhpmyadminAlias
                       
- add # to the following 4 lines
#    AuthName "phpMyAdmin"
#    AuthType Basic
#    AuthExternal pwauth
#    require user admin
#    Satisfy All
restart the httpd:
service httpd restart
 

4. go to https://myserver/phpmyadmin
fill in your dba username and password
create databases users and specific rights
developers and system specialist can now log on to the database using specific users with specific rights.

Good luck,

Lars

Title: Contrib Feedback: phpMyAdmin
Post by: sfp on February 01, 2006, 01:53:54 AM

This contrib does not seem to be compatible with SME Server 7.0pre1.
bug 612 refers.

Title: Contrib Feedback: phpMyAdmin
Post by: cc_skavenger on February 01, 2006, 03:40:49 AM

A SME 7.X compatable version can be found here:
http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm

Title: Contrib Feedback: phpMyAdmin
Post by: CharlieBrady on February 01, 2006, 06:10:31 PM

Quote from: "cc_skavenger"

A SME 7.X compatable version can be found here:
http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm

Please shut down this thread and make sure that the wiki page about contrib compatibility contains all this information. Thanks.