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

                        PURPOSE: When a change is created or edited as required, a project is created in Zoho Projects respectively. Here is an example of creating a project in Zoho Projects when a change is created under a specific site in SDP MSP. TESTED IN MSP BUILDS: ...