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 / 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 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 ...Update Change Impact based on Selected Assets Business impact value
This requirement includes 3 global functions, 1 change custom action and 1 change custom trigger. Step 1: getConfiguration Global Function 1) Go to Admin -> change custom function -> global function-> Add new --> Mention function name and Return ...Change roles
SELECT chdt.changeid "Change ID", chdt.title "Title", orgaaa.first_name "Change Requester", ownaaa.first_name "Change Owner", ...Change approval
SELECT chdt.CHANGEID AS "Change ID", chdt.TITLE AS "Title", orgaaa.FIRST_NAME AS "Change Requester", qd.QUEUENAME AS "Group", ownaaa.FIRST_NAME AS "Change Owner", catadef.CATEGORYNAME AS "Category", priodef1.PRIORITYNAME AS "Priority", ...