1  LICENSE: The current code should work on all Linux, Unix, *BSD systems thus making it GPL for
2  all those platforms, however if you have to modifiy code to get it to work on a windows machine,
3  you have made it useless to theource community so if you want to port this app to windows
4  talk to me about a payment.
5 
6  What is this PCCS MySQLDatabase Admin Tool?
7 
8  PCCS MAT is a web based MySQLDatabase Admin tool written in PHP.
9  It is being designed as a tool for managing USER connections to the MySQL DB.
10  These connections can be Web (local) or applications like MS Access, Excel (remote).
11  The DB admin can determine if the connection is made from anywhere, or just from
12  a single location. Or from the localhost, however if you make it the localhost, we
13  assumed you were wanting to setup a web application and added a setup just for web applications.
14  We are also designing it to be the PHP web Hosting Adminstators tool.
15 
16  Current features and plans:
17 
18  Manage Database Module;
19          
20  View Database Tables and Optimize them.
21          
22  Backup Database : mysqldump --opt dbname > date-time-dbname.sql
23  then tar -czf ./date-time-dbname-tar.gz ./date-time-dbname.sql
24  To backup database it requires you to download the backup to a remote site.
25          
26  View Schema: this is just a mysqldump --opt -d (I'm working on code that will change
27  this to Create new Database, from the selected database and grant users permissions to
28  new database) I will give option with data (remove -d) or without.
29          
30  Drop Database: Prompts you before dropping database.
31          
32  Query Database: This section will REALLY be under development in the 1.x versions.
33  The development plans for this feature:
34 
35  Report creation: you create the SQL query that brings back the data you want in
36  a weekly, monthly, report. Save that query, define if you want it to be a cvs
37  dump, excel file dump. Write this info to a file and make it available just
38  by a click, then all you have to do is download the report data...
39                  
40  View Tables: Here we allow you to optimize your database tables, view column
41  information and display the number of records in that table. (plan to add grant and revoke
42  support at the table level)
43          
44  User Management Module: This module allow the MySQL administrator to create and modify
45  user accounts. The admin has the option to create 4 different groups of accounts.
46  ADMIN : GRANT ALL
47  BASIC : GRANT SELECT ...
48  ADVANCE: GRANT SELECT, INSERT,UPDATE,DELETE
49  OPERATOR : GRANT SELECT,INSERT,UPDATE,DELETE,FILE,INDEX,DROP,RELOAD
50  the password is created/updated using the INDENTIFIED BY 'password'
51          
52  The DB admin has the option to give the user access to all databases or just one
53  (working on code to allow multiple databases)...
54          
55  The Modify User option in the User Management module allow the administrator to modify
56  current user access rights to their servers. (Needs an interface, "function before
57  pretty") This option allows edit of the mysql.user table and the mysql.db table.
58          
59  The Web Application/Hosting Module: This module's design is to allow the MySQL
60  administrator and/or Web Hosting Administrator to create accounts for applications that
61  will connect to their servers. We plan to design this module to accept install files
62  that tell the system how to install and setup PHP applications. (The PHP InstallScript
63  has been released and is available at (URL) in an effort to get in out to PHP
64  Developers). It will also support the PHP Backup Script which makes backing up Web
65  application database.
66 
67  Feature to be added to this module is;
68  define webhosting share dir variable.
69  define a webosting skel directory: location to store PHP Applications. will be used to copy
70  Applications that a subscriber may want. News System, Message System, FeedBack Form etc and
71  other applications that support the phpinstallscript... from
72  skel to a directory created for the user.
73  create directory for userid being created
74 
75 
76 
77 
78                  
79