Add MySQL User

To avoid any security risks the refbase install.php script adds a new MySQL user to the MySQL database during installation. This user is granted only those permissions that are required to access the literature database. If you want to add this MySQL user manually (i.e. without install.php), run the MySQL command interpreter with root permissions and use the following GRANT statement:

GRANT SELECT,INSERT,UPDATE,DELETE ON MYSQL_DATABASE_NAME_GOES_HERE.* TO MYSQL_USER_NAME_GOES_HERE@localhost IDENTIFIED BY 'MYSQL_PASSWORD_GOES_HERE';

The italic items within the above statement must match the information you've provided in initialize/db.inc.php. As an example, if you've entered the following in initialize/db.inc.php:

$hostName = "localhost";
$databaseName = "literature";
$username = "litwww";
$password = "%l1t3ratur3?";

your GRANT statement would read:

GRANT SELECT,INSERT,UPDATE,DELETE ON literature.* TO litwww@localhost IDENTIFIED BY '%l1t3ratur3?';

This adds a new user litwww to the user & db tables of the mysql database and allows him to use only the SQL statements SELECT, INSERT, UPDATE and DELETE with any table of the literature database.