When enabling Query Analyzer by changing the MySQL Server, you need to shutdown your server, edit the MySQL configuration file, and then restart MySQL. You will also need to change your Agent/proxy configuration so that the Agent/proxy is listening on the original MySQL TCP/IP port. To use this method:

  1. Edit the /etc/my.cnf or other MySQL configuration file and change or add the port setting from it’s current value (default 3306), to another value. For example:
    port                                            = 3307
  2. Shutdown your MySQL Server.
  3. Startup your MySQL Server and confirm that is running.
  4. Edit your MySQL Enterprise Monitor Agent configuration so that the agent/proxy is listening for connections on the original MySQL port:
    proxy-backend-addresses =
  5. Stop and restart MySQL Enterprise Monitor Agent.

Post By Editor (2,827 Posts)

Website: →