Connection for Controluser as defined in your configuration failed.

Using the event Scheduler (scheduled Tasks) in MySQL,

The statement was written, and the operation was OK, but there was no expected result. Online summary of the reasons for the failure of a very many scheduled tasks. There is no one for me.

Open the event table in phpMyAdmin and find the following red tip: Connection forcontroluser as defined in your configuration failed.

This sentence pasted on the internet search, many are some foreign sites, did not understand, and then translated the meaning of this sentence is: "Due to the control user defined in the configuration of the connection failed."

Apart, find the configuration file for Phpyadmin config.sample.inc.php, and see a paragraph like this:

/* PMA User Advanced Features */
$cfg [' Servers '] [$i] [' controluser '] = ' PMA ';
$cfg [' Servers '] [$i] [' controlpass '] = $password;

The original user is the advanced user, before installing the integration environment did not let the user input, just need to enter the password,

So I usually use the root account, but this account is not an advanced user, and then decisively replaced the above PMA to root.

Back to the Event table page, the red hint disappears. My planning task starts to work.

。。

Some people on the internet have summed up the reasons for the failure of very many common event scheduling. It is important to note that:

The scheduled task fails after the server shuts down, which is not agreed in the actual production.

Ability to change MySQL configuration file resolution, add a event_scheduler=on in My.ini

Connection for Controluser as defined in your configuration failed.