Navicat under MySQL task plan

The following two points need to be noted for MySQL's scheduled tasks

1. No turn on this function, SHOW VARIABLES like ' Event_scheduler ';

If you do not have to open the My.ini or my.cnf
[Mysqld]
Add Event_scheduler=on

2. If the client is remote access, verify that the user is authorized:

ERROR 1044:access denied for user: ' @127.0.0.1 ' to database ' MySQL '

Indicates that you have not delegated permissions to the remote connection account, because the security of MySQL is constantly improving, the permission settings are denied by default, you must open your own permissions.

Log in to the MySQL database with mysql-h 192.168.0.1-u root-p mysql command on the server

Then use the grant command to delegate permissions.

GRANT all privileges on *. * to root@localhost identified by ' Root-password ' with GRANT OPTION;

GRANT all privileges on *. * to root@127.0.0.1 identified by ' Root-password ' with GRANT OPTION;

GRANT all privileges on * * to [email protected] '% ' identified by ' Root-password ' with GRANT OPTION;

For example:

GRANT all privileges on * * to [email protected] '% ' identified by ' 123456 '

Note: Modify the "User" "IP Address" "password" in the above command as appropriate.

After completing these two steps, you can use the client to create the task, which lists only the scheduled tasks that were created once a day, the current time + 6 hours after the open, directly on the code:

CREATE EVENT ' event_emulate_statistics ' on SCHEDULE every 1 day starts Current_timestamp + INTERVAL 6 Houron completion not Preserveenabledocreate TABLE IF not EXISTS mooc_sf_emulate_statistics_day (id BIGINT not null,emulate_id bigint,learn_ Day_number integer,create_time datetime,modify_time datetime,delete_flag bit,primary KEY (id));

You can dynamically control whether the event scheduler is enabled by setting the value of the global variable Event_scheduler.
See if Event_scheduler opens mysql> SHOW VARIABLES like '%event% ';
Set the mysql> set GLOBAL event_scheduler=on to open;

Detailed features reference open source China Blog: http://www.oschina.net/question/4873_20927

Navicat under MySQL task plan