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 ).

                  New to ADSelfService Plus?

                    • Related Articles

                    • Port occupied.

                      If the port is already occupied (as in the screenshot), prompt as in below message will appear. Case 1: If the application is running in the services and you try to start the application in CMD as well this error occurs ,if the application is started ...
                    • Port Occupied / Application Layer Starting

                      If the port is already occupied (as in the screenshot), prompt as in below screenshot will appear.  Find application that uses the port by following the steps below, Execute, netstat -oan (This command will display list of processes and the ports ...
                    • How to change application port

                      1. Stop the application  2. Open Command Prompt as Admin 3. Go to ManageEngine\ServiceDeskPlus-MSP\bin 4. Invoke command changeWebServerPort.bat [newportnumber] [Protocol http or https] 5. Start the application. Refer below screenshot  Note : ...
                    • How to change the database from MySQL/PostgreSQL to MSSQL

                      The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB.    For ...
                    • Integrating Zoho Projects with SDP MSP change management

                      Overview: Automatically creating projects in Zoho Projects based on the changes in SDP MSP keeps everything in sync without manual updates. This means all tasks and updates on a Change are automatically reflected in Zoho Projects, making it easier to ...