Connection for controluser as defined in your configuration failed.

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.