Connection for controluser as defined in your configuration failed.

Use the practice scheduler (Scheduler) in MySQL ),

After the statement is written, the execution is OK, but there is no expected result. I have summarized the reasons for the failure of many scheduled tasks on the Internet, and none of them is suitable for me,

Open the event table in phpMyAdmin and find the following red series: Connection for controluser as defined in your configuration failed.

I pasted this sentence on the Internet and searched it for some foreign websites, but I didn't understand it. Then I translated the following sentence: "because the control user connection defined in the configuration fails ".

If you do not want to talk about it, find the configuration file config. sample. Inc. php of phpyadmin and see the following section:

/* PMA user advanced features */
$ Cfg ['servers'] [$ I] ['controluser'] = 'pma ';
$ Cfg ['servers'] [$ I] ['controlpass'] = $ password;

It turns out that this user is an advanced user. You didn't have to enter the user before installing the integrated environment. You only need to enter the password,

As a result, I usually use a root account, but I do not know that this account is not a senior user. Then I replace the above PMA with the root account,

Go back to the table page of the event, and the red prompt disappears. My scheduled task starts to work ....

Some people on the Internet have summarized many common causes of failed event scheduling. Note the following:

The scheduled task fails after the server is shut down and restarted, which is not allowed in actual production.

You can change the MySQL configuration file and add event_scheduler = on to my. ini.