PHP MySQL User Management: List, add, modify and remove MySQL server accounts

Recommend this page to a friend!
  Info   Example   View files (5)   Download .zip   Reputation   Support forum (1)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 566 This week: 1All time: 5,320 This week: 255
Version License PHP version Categories
myusers 1.0.0BSD License5.3PHP 5, Databases, User Management, Sy...
Description Author

This package can list, add, modify and remove MySQL server user accounts.

It can connect to the main accounts mysql database of a given MySQL server using PDO with the root account to perform operations with the MySQL server users.

There is one class that abstracts all the attributes and options of each MySQL user permission, like user name, password, privileges, etc..

The main class can perform all sorts of operations with database user records like:

- Load user permissions for a given database and host
- Check if a given user records exist
- Get the hash of a given password
- Create new user records
- Grant or revoke privileges of a given user
- Get user privileges for all databases he has access
- Delete a given user
- Make server reload the latest user privileges

Recommendations

Manage MySQL user accounts
I need to create and delete MySQL users

Innovation Award
PHP Programming Innovation award nominee
November 2014
Number 11
Before an application can access a MySQL database, there must exist at least one user record in a special MySQL database that defines the user name, password, the databases and tables the user can access and the types queries that can be execute on those tables.

This class can perform the necessary operations to manipulate MySQL server user records with the permissions the users need to access the databases on the current server.

Manuel Lemos
Picture of Maik Greubel
  Performance   Level  
Name: Maik Greubel <contact>
Classes: 10 packages by
Country: Germany Germany
Age: ???
All time rank: 114274 in Germany Germany
Week rank: 136 5 in Germany Germany
Innovation award
Innovation award
Nominee: 4x

  Files  
File Role Description
MyUsers.php Class The main class
User.php Class OR Mapping class needed by MyUsers
composer.json Data To create class documentation
demo.php Example Small demo to show capabilities
phpdoc.dist.xml Data PHPDocumentor configuration

 Version Control Unique User Downloads Download Rankings  
 0%
Total:566
This week:1
All time:5,320
This week:255
User Comments (1)
 

For more information send a message to info at phpclasses dot org.