MySQL Notifier resides in the system tray and provides visual status information for your MySQL server instances. A green icon is displayed at the top left corner of the tray icon if the current MySQL server is running, or a red icon if the service is stopped.
MySQL Notifier automatically adds discovered MySQL services on the
local machine, and each service is saved and configurable. By
default, the Automatically add new services whose name
contains option is enabled and set to
mysql. Related Notifications
Options include being notified when new services are
either discovered or experience status changes, and are also
enabled by default. And uninstalling a service will also remove
the service from MySQL Notifier.
Clicking the system tray icon reveals several options, as the following sequence of figures show.
The Service Instance menu is the main MySQL Notifier window, and enables you to stop, start, and restart the MySQL server.
The Refresh Status option to manually refresh the status of all monitored services (in both local and remote computers) and MySQL instances. The figure that follows shows the menu for localhost (Online).menu includes several links to external applications (if they are installed) and a
The main menu will not show themenu when there are no services being monitored by MySQL Notifier.
The, menu (see the figure that follows) configures MySQL Notifier and includes options to:
Use colorful status icons: Enables a colorful style of icons for the tray of MySQL Notifier.
Run at Windows Startup: Allows the application to be loaded when Microsoft Windows starts.
Automatically Check For Updates Every # Weeks: Checks for a new version of MySQL Notifier, and runs this check every # weeks.
Automatically add new services whose name contains: The text used to filter services and add them automatically to the monitored list of the local computer running MySQL Notifier, and on remote computers already monitoring Windows services.
Ping monitored MySQL Server instances every # seconds: The interval (in seconds) to ping monitored MySQL Server instances for status changes. Longer intervals might be necessary if the list of monitored remote instances is large.
Notify me when a service is automatically added: Will display a balloon notification from the taskbar when a newly discovered service is added to the monitored services list.
Notify me when a service changes status: Will display a balloon notification from the taskbar when a monitored service changes its status.
Automatic connections migration delayed until: When there are connections to migrate, postpone the migration by one hour, one day, one week, one month, or indefinitely.
The Services tab open as the next figure shows., menu enables you to configure the monitored services and MySQL instances. First, with the
The Instances tab is similar to the Service tab as the following figure shows:
Adding a service or instance (after clickingin the window) enables you to select a running Microsoft Windows service or instance connection, and configure MySQL Notifier to monitor it. Add a new service or instance by clicking service name from the list and then to accept. Multiple services and instances may be selected, as the following figure shows.
Optionally, you can select a connection from MySQL Workbench to monitor. The list can be filtered and sorted to show instances that are already monitored. Click, shown in the next figure, to create a new connection.
For issues that are not documented here, visit the MySQL Notifier Support Forum for MySQL Notifier help and support.
Problem: attempting to start/stop/restart a MySQL service might generate an error similar to "The Service MySQL
VERSIONfailed the most recent status change request with the message "The service mysql
VERSIONwas not found in the Windows Services".
Explanation: this is a case-sensitivity issue, in that the service name is MySQL
VERSIONcompared to having mysql
VERSIONin the configuration file.
Solution: either update your MySQL Notifier configuration file with the correct information, or stop MySQL Notifier and delete this configuration file. The MySQL Notifier configuration file is located at
%APPDATA%is a variable and depends on your system. A typical location is "C:\Users\
YourUsername\AppData\Running\Oracle\MySQL Notifier\settings.config" where
YourUsernameis your system's user name. In this file, and within the ServerList section, change the ServerName values from lowercase to the actual service names. For example, change mysql
VERSION, save, and then restart MySQL Notifier. Alternatively, stop MySQL Notifier, delete this file, then restart MySQL Notifier.
Problem: when connecting to a remote computer for the purpose of monitoring a remote Windows service, the Add Service dialog does not always show all the services shown in the Windows Services console.
Explanation: this behavior is governed by the operating system and the outcome is expected when working with nondomain user accounts. For a complete description of the behavior, see the User Account Control and WMI article from Microsoft.
Solution: when the remote computer is in a compatible domain, it is recommended that domain user accounts are used to connect through WMI to a remote computer. For detailed setup instructions using WMI, see Section 1.4.2, “Setting Up Remote Monitoring in MySQL Notifier”.
Alternatively, when domain user accounts are not available, Microsoft provides a less secure workaround that should only be implemented with caution. For more information, see the Description of User Account Control and remote restrictions in Windows Vista KB article from Microsoft.