1402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll-- Note: use the same username/password values here as set in 
2402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll--   includes/parsecvs-dbaccess.php and in
3402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll--   www/projectName/includes/searchcvs-dbaccess.php
4402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll--
5402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll-- You can load this file into mysql using: 
6402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll-- $ mysql -u root -p < mysql-users.dump
7402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll
8402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll-- Note that the database name for the stored CVS data is `modeling`, as in the Eclipse Modeling Project. 
9402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll-- You'll probably want to change that for your project's needs.
10402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll
11402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll-- Local access (cvs parser) granted to read/write for user 'dbaccessrw' with password 'dbaccessrwpassword'
12402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael MollCREATE USER 'dbaccessrw'@'localhost' IDENTIFIED BY 'dbaccessrwpassword';
13402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael MollGRANT USAGE ON *.* TO 'dbaccessrw'@'localhost' IDENTIFIED BY 'dbaccessrwpassword' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
14402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael MollGRANT ALL PRIVILEGES ON `dbaccessrw`.* TO 'dbaccessrw'@'localhost';
15402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll
16402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael Moll-- Remote access (website) granted to read only for user 'dbaccessro' with password 'dbaccessropassword'
17402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael MollCREATE USER 'dbaccessro'@'%eclipse.org' IDENTIFIED BY 'dbaccessropassword';
18402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael MollGRANT USAGE ON *.* TO 'dbaccessro'@'%eclipse.org' IDENTIFIED BY 'dbaccessropassword' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;
19402794e73aed8611d62eb4b01cd155e2d76fcb87Raphael MollGRANT SELECT ON `modeling`.* TO 'dbaccessro'@'%eclipse.org';
20