AddAPEL

APEL - MonBox

Just drop a few commands and then ... write a page at some time ^^

mysql> GRANT USAGE ON *.* TO 'accounting'@'%' IDENTIFIED BY PASSWORD '31234566789';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT ALL PRIVILEGES ON <tt>accounting</tt>.* TO 'accounting'@'%'   
    -> ;
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, CREATE TEMPORARY TABLES ON <tt>accounting</tt>.* TO 'accounting'@'%';
Query OK, 0 rows affected (0.00 sec)

 /opt/glite/share/glite-apel-core/scripts/apel-db-config.py --user accounting --password 123456689 --database accounting --gkhost ce01.begrid.be --cehost ce01.begrid.be -o ./accounting.sql

https://twiki.cern.ch/twiki/bin/view/LCG/TheLCGTroubleshootingGuide