Service Management Database access

One OneClick:

[spectrum@nmsrv7 root]$ /etc/init.d/processd stop

[spectrum@nmsrv7 spectrum]$ /opt/spectrum/mysql/bin/mysqld --defaults-file=/opt/spectrum/mysql/my-spectrum.cnf --skip-grant-tables
/opt/spectrum/mysql/bin/mysqld: ready for connections.
Version: '4.1.11-standard'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Edition - Standard (GPL)

New shell:

[spectrum@nmsrv7 mysql]$ bin/mysql --user=root

mysql> flush privileges;

mysql> grant select on reporting.* to 'juraj'@'%.cern.ch' identified by 'reppas'

mysql> flush privileges;

Back to the first shell:

Killed

[spectrum@nmsrv7 root]$ /etc/init.d/processd start

-> modify /afs/cern.ch/user/s/spectrum/public/monitoring/services > vi db.php

-- GregoryBevillard - 27 Mar 2008