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

Edit | Attach | Watch | Print version | History: r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r2 - 2020-08-19 - TWikiAdminUser
 
    • Cern Search Icon Cern Search
    • TWiki Search Icon TWiki Search
    • Google Search Icon Google Search

    Sandbox/SandboxArchive All webs login

This site is powered by the TWiki collaboration platform Powered by PerlCopyright & 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
or Ideas, requests, problems regarding TWiki? use Discourse or Send feedback