Often, during the development process developers need to test their code. Project owners have the ability to connect a MySQL database to their project. This feature allows the Project Owner to administer a test database for use by project members. Using the MySQL interface, the project owner can give access permissions to users per their needs. Project developers may use this feature for creating applications and as a test bed. The project database is a feature available for the convenience of project members. The schema for the database is secured and cannot be altered. Project members can add and remove data from the tables, but the tables cannot be manipulated. Further, since this is not a central feature to the core project, the project database is not a supported function.
To attach a database to your project you must activate the servlet to create the database. The resulting database will have the same name as your project; a project named gamemaster will have a database named gamemaster. You will be prompted to supply a password for this database. The database password is not related to your project password and, since you may wish to share it with others, should not be the same as any of your other passwords.
Initially, only the project owner is granted permissions to the database. Once you have completed the database creation process you are free to grant access and permissions to project members at your own discretion. To provide members access to the project database you will need to grant them the appropriate permissions. To do so, use the MySQL grant command. Likewise, to remove a users access to the project database use the MySQL revoke command. Privileges available for users of the project database are select, insert, update, delete and grant. Using the project database Using JDBC, Perl DBI, the MySQL client program or any other interface that supports MySQL, developers can write programs to access the project database. To remove all data from a specific table you would use the following command:
delete from [table_name]