Skip navigation links
MySQL Enterprise Monitor 2.1 :: 9 The Query Analyzer Page :: 9.1 Enabling Query Analyzer :: 9.1.2 Enabling Query Analyzer by Changing MySQL Server
9.2 Getting Detailed Query Information »
Section Navigation      [Toggle]

9.1.2. Enabling Query Analyzer by Changing MySQL Server

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-address=:3306
proxy-backend-addresses = 127.0.0.1:3307

  5. Stop and restart MySQL Enterprise Monitor Agent.

You should now be able to connect to your MySQL server through the MySQL Enterprise Monitor Agent by connecting on the original port: 

shell> mysql --host=127.0.0.1