Project

General

Profile

Actions

Database Setup After Webserver initialization Shared » History » Revision 1

Revision 1/7 | Next »
Anchi Cheng, 03/04/2011 04:17 PM


Additional Setup After Webserver initialization

If your webserver installation is successful, a number of tables will be propagated in the databases. If you are using the more secured privilege settings we recommended in Database Server Installation, you should expand the privileges of these three tables at this point:

GRANT DELETE ON leginondb.ViewerImageStatus TO usr_object@'localhost';
GRANT DELETE ON leginondb.ImageStatusData TO usr_object@'localhost';
GRANT DELETE ON projectdb.processingdb TO usr_object@'localhost';

If you use Leginon to do robotic grid screening, you will also need to do the following to grant delete privileges to the these tables at the mysql prompt:

GRANT DELETE ON projectdb.gridboxes TO usr_object@'localhost';
GRANT DELETE ON projectdb.grids TO usr_object@'localhost';
GRANT DELETE ON projectdb.gridlocations TO usr_object@'localhost';

Updated by Anchi Cheng over 13 years ago · 1 revisions