mysql command

path:
/opt/FlexMaster/3rdparty/mysql/mysql-enterprise-5.0.52-linux-i686/bin/
Get into the mysql command:
[root@localhost bin]# ./mysql -uroot -p --socket=../mysql.sock
./bin/mysql -u root -p --socket=../mysql.sock

the mysql connamd:
mysql> grant all privileges on *.* to root@"%";
mysql> grant all privileges on itms.* to root@'%' identified by 'admin';
mysql> select * from task;
mysql> Select * from task_attrs where taskId=135;

sqlyog:
grant all privileges on *.* to root@"%" identified by 'ruckus' with grant option;
Check the task:
mysql> select * from task_device where taskId=734 and isCompleted=0;
Count the event amount:
mysql>use itms;
mysql>select count(*) from event;

Delete entries:
delete from connectivity;
delete from status_msg;
delete from hotzone_associate;
delete from event;
delete from deviceattr;
delete from devicemethods;
delete from deviceparams;
delete from task_attrs;
delete from task_device;
delete from task;
delete from device;
delete from auto_config_rule;
delete from inventory_comments;
delete from inventory;