PHP Classes
elePHPant
Icontem

dbuser: Manage MySQL or PostgreSQL users using reconfig

Recommend this page to a friend!
  Info   View files Documentation   Screenshots Screenshots   View files View files (9)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2014-11-24 (1 year ago) RSS 2.0 feedNot yet rated by the usersTotal: 23 All time: 8,605 This week: 901Up
Version License PHP version Categories
dbuser 1.0GNU General Publi...5.0.0PHP 5, Databases, Systems administration
Description Author

This package can manage MySQL or PostgreSQL users using the reconfig package.

It provides classes that extend the base class of the reconfig package to perform operations to manage the users of a MySQL or PostgreSQL database.

Currently those classes can list, grant, update and revoke user privileges.

Picture of giuseppe lucarelli
Name: giuseppe lucarelli <contact>
Classes: 5 packages by
Country: Italy Italy
Innovation award
Innovation award
Nominee: 2x

Details
DBUser is a "reconfig" module to manage mysql/postgresql users.
Pay attention to postgresql, the script doesn't remove users but revoke privileges only. Use "dropuser" to do that.

INSTALL
download "reconfig" at:
http://www.phpclasses.org/package/8572-PHP-Get-configuration-from-files-pages-and-databases.html
install DBuser files into the same directory
if you want user authentication enable the rows below (user.php):

    $REC->auth_type='httpHeader';
    $REC->auth_passwd='.htpasswd';
    $REC->auth_script = 'validate.php';
    $REC->auth_func = 'ValidateUser';
    $REC->auth_driver = __DRIVER__;
    $REC->auth_host = @$_POST['auth_host'];
    $REC->auth_user = @$_POST['auth_user'];
    $REC->auth_pass = @$_POST['auth_pass'];

create youw .htpasswd file and change 'exec' with 'login' (js/user.js):

    $('#building').reconfig({action: ['exec','build']});
    to:
    $('#building').reconfig({action: ['login','build']});


USAGE

for mysql:
http://host/user.php
http://host/user.php?driver=mysql

for postgresql:
http://host/user.php?driver=pgsql

enjoy
Screenshots  
  • pgsql.jpg
  • mysql.png
  Files folder image Files  
File Role Description
Files folder imagecss (1 file)
Files folder imagejs (1 file)
Files folder imagesql (2 files)
Files folder imagexml (2 files)
Accessible without login Plain text file README Doc. documentation file
Accessible without login Plain text file user.html Data html file
Accessible without login Plain text file user.php Example main php script

  Files folder image Files  /  css  
File Role Description
  Accessible without login Plain text file user.css Data css file

  Files folder image Files  /  js  
File Role Description
  Accessible without login Plain text file user.js Data javascript code

  Files folder image Files  /  sql  
File Role Description
  Plain text file class.mysql.php Class php class for mysql
  Plain text file class.pgsql.php Class php class for postgresql

  Files folder image Files  /  xml  
File Role Description
  Accessible without login Plain text file xml.mysql.php Aux. php class for mysql
  Accessible without login Plain text file xml.pgsql.php Aux. php class for postgresql

 Version Control Unique User Downloads Download Rankings  
 0%
Total:23
This week:0
All time:8,605
This week:901Up