Strange MySQL Popup "Mysql Installer is running community mode"
MysqlMysql Problem Overview
I have installed a recent community version of MySQL from MySQL site. The version is 5.6.x.
It was done using an installer and I also chose the option to create a MySQL service on Windows so that I can simply start the service. The service was set to not start automatically.
Although I am not actively using MySQL, while I am working on my PC on something else, a strange pop-up displays,
> MySQL Running in community mode.
Does something, prints on screen, and closes:
I am surprised to see this and wonder: what is it doing - connecting to a remote server and doing what? Does someone know the internals and how to prevent it from connecting to a remote server?
Could this be a security issue?
Mysql Solutions
Solution 1 - Mysql
Go to Control Panel > System and Security > Administrative Tools and open Task Scheduler.
In the Task Scheduler navigate to Task Scheduler Library > MySQL and select Installer.
From the list at the center of the window right-click ManifestUpdate and select Disable.
Answer found here.
Solution 2 - Mysql
Since the other answers require OS interaction I figured it would be beneficial to provide the "MySQL" way.
> I am surprised to see and wonder what is it doing and connecting to a > remote server and doing what?
It's keeping the MySQL Product Catalog up to date. As described in the documentation,
> This option uses the Windows Task Scheduler to schedule a task named > "ManifestUpdate". (this is the scheduled task that is disabled the OS way)
> Does someone know the internals and how to prevent it from connecting > to a remote server?
To prevent it from connecting you can disable it without going through the OS:
- Start the MySQL installer
- Click the wrench image
- Uncheck the checkbox to disable automatic updating
You're ready to go...
> This could be a security issue?
I'm not a security expert but it's connecting to the same people you trusted to get the software from so I think it's more of a nuisance than a risk.
Luckily, you can manually update it as needed by clicking the Catalog... button seen above and force it.
Solution 3 - Mysql
It's just the MySQL update function.
Following these http://answers.microsoft.com/en-us/windows/forum/windows_7-security/what-is-taskengexe/526f43d3-d311-4637-a19a-a76f1ce351fb you should be able to turn it off:
> 1. Go to the Start menu. > 2. Type task scheduler and press enter. > 3. Press continue on the UAC popup. > 4. In the left pane of task scheduler, underneath Task Scheduler Local, right-click on Task Scheduler Library. > 5. In the View submenu, make sure the Show Hidden Tasks option is checked. > 6. Widen the Name column in the center pane. The hidden task that is likely at fault has a name that starts with User_Feed_Synchronization, > followed by a dash and a bunch of digits inside a curly brace. > 7. Select that task in the middle pane by clicking on its name. > 8. To verify that this scheduled task is creating all those taskeng.exe processes, select the History tab in the middle pane near > the middle of the screen. If you expand out the Level and Date and > Time Columns, you should see a bunch of errors and date and times that > are 5 minutes apart. If that's the case, then this task is the > problem. > 9. On the rightmost pane, select Disable. > 10. There may be more than one scheduled task like this, so you'd need to disable any or all that were causing problems. > > From an answer by Liza.Z on question "What is taskeng.exe?" on http://answers.microsoft.com/, written April 23, 2013 retrieved Feb. 22, 2016
Solution 4 - Mysql
It may be better not to completely disable the updater but make it check less often than once a day, which seems over the top. You can not do that without using the Task Scheduler. Double-click the "ManifestUpdate" Name in the Task Scheduler to open the Properties window and select the Triggers tab, here you can use the "Edit..." button to set the task to run as [in]frequently as you like. This is what I have done:
Be warned that the next MySQL update you do decide to install might undo anything done directly in the Task Scheduler.
Solution 5 - Mysql
A lot of answers are suggesting disabling the updater, or having it run less frequently.
If you'd like to keep it running, but not just have the console popping up to intrude on what you're doing, consider running it under another account, or checking the box to run whether or not the current user is logged in. Either of these will make it run silently in the background.
