PHP Classes

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    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 30 This week: 2All time: 11,034 This week: 94Up
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
Age: 65
All time rank: 85433 in Italy Italy
Week rank: 51 Up2 in Italy Italy Up
Innovation award
Innovation award
Nominee: 2x

Documentation

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  
  • mysql.png
  • pgsql.jpg
  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:30
This week:2
All time:11,034
This week:94Up