View source for 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 <code>GRANT</code> statement:

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

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 <code>GRANT</code> 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 <code>SELECT</code>, <code>INSERT</code>, <code>UPDATE</code> and <code>DELETE</code> with any table of the literature database.

[[Category:Installation]]