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:
- Edit theÂ
/etc/my.cnfor other MySQL configuration file and change or add theÂ
portsetting from it’s current value (default 3306), to another value. For example:
port = 3307
- Shutdown your MySQL Server.
- Startup your MySQL Server and confirm that is running.
- 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
- Stop and restart MySQL Enterprise Monitor Agent.