Re: Port change configuration

[Javier Treviño]

Hello Mahendra,
Since you are writing on this forum I am assuming you are talking about Windows installations.

You have 2 options to do the change:


1. Manually update the INI configuration file with new ports:
The configuration file should be located where you specified the Data Directory upon installation of the MySQL Server. If you did not change the Data Directory it should be under "C:\ProgramData\MySQL\MySQL Server X.X".
Bear in mind that you must stop the Server first, change config file, then restart.
You would also need to manually update the Windows Firewall exception the MySQL Installer created for the original port, to set the new port. Or create a new Firewall exception.

2. Reconfigure using the MySQL Installer for Windows:
On the MySQL Installer for Windows, you can select "Reconfigure", and that will take you through the configuration wizard again where you can set the new Port and let the MySQL Installer take care of the Windows Firewall exception.
Downside about reconfiguring is, you will loose any manually added configuration (like the one you mentioned for replication), so you would anyway need to go to the config file and add that configuration back.

Best regards.

====================================
Javier Treviño
MySQL on Windows Team