User Tools

Site Tools


mysql_queries

Mysql queries

Bijk.com is ready for monitoring MySQL deamon on your servers.

After setting Bijk.com read-only access to your mySQL, you will get this graphs:

CHANGE query requests graph

SELECT query requests gprah

  1. In file /etc/bijk/bijk-node-plugins.conf change this variables MYSQL_PASS:
MYSQL_USER = bijk
MYSQL_PASS = {vygenerovat pro uzivatele heslo}

2. restartovat bijk

/etc/init.d/bijk-node restart

3. spustit mysql konzoli s opravnenim pro tvorbu novych uzivatelu (typicky prikazem `mysql` pod rootem na prikazove radce serveru) a vytvorit uzivatele bijk, ktery nebude mit opravneni k zadne databazi:

CREATE USER 'bijk'@'localhost' IDENTIFIED BY '{drive vygenerovane
heslo}'; FLUSH PRIVILEGES;

4. pristup lze otestovat z prikazove radky serveru nasledujicim prikazem. pokud se podari do mysql konzole prihlasit, lokalni pristup je v poradku:

mysql -u bijk -p{drive vygenerovane heslo}

(mezi -p a heslem nesmi byt mezera ! kdyby byla, na heslo by se to interaktivne ptalo.)

mysql_queries.txt · Last modified: 2010/05/20 14:38 by zdenek