How to change the port on which MySQL runs

How to change the port on which MySQL runs

The following are the instructions to change the port for the MySQL database.


1. Edit the ManageEngine\ServiceDesk\Bin\StartDb.bat file and change "33366" to the port on which the default MySQL runs.


2. Edit the ManageEngine\ServiceDesk\Bin\stopdb.bat file and change "33366" to the port on which the default MySQL runs.


3. Edit the ManageEngine\ServiceDesk\Bin\server\default\deploy\mysql-ds.xml file and change "33366" to the port on which the default MySQL runs. ( Change "localhost" to the IP address or hostname of the server on which MySQL runs, if you want to change the host ).