Код: Выделить всё
server# mysql -uroot -p zabbix
mysql> truncate table node_cksum;
Query OK, 0 rows affected (0.23 sec)
* по мотивам http://www.zabbix.com/forum/showthread.php?t=12825
Код: Выделить всё
server# mysql -uroot -p zabbix
mysql> truncate table node_cksum;
Query OK, 0 rows affected (0.23 sec)
Код: Выделить всё
zabbix# mysql -uroot -pпароль
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 25693
Server version: 5.5.30 Source distribution
mysql> use zabbix;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> update users set passwd=md5('12345') where alias='admin';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0