When enabling Query Analyzer by changing the MySQL Server, shut down your server, edit the MySQL configuration file, and then restart MySQL. Also, change your Agent configuration so that the proxy listens on the original MySQL TCP/IP port. To use this method, follow these steps:
/etc/my.cnf or other MySQL
configuration file and change or add the
port setting from its current value
(default 3306), to another value. For example:
port = 3307
Shut down your MySQL Server.
Start your MySQL Server and confirm that is running.
Edit your MySQL Enterprise Agent configuration so that the proxy listens for connections on the original MySQL port:
proxy-address=:3306 proxy-backend-addresses = 127.0.0.1:3307
Stop and restart MySQL Enterprise Agent.
You can now connect to your MySQL server through the MySQL Enterprise Agent Proxy Service by connecting on the original port:
shell> mysql --host=127.0.0.1