How to change MySql port

There are times when applications tend to use the same port. And this causes conflicts. Like malfunctioning of the applications which are involved.

 

In this guide I’m going to show you how to change the port which is used by MySql. This guide is only for those who are using Wampserver and Windows Operating System.

First thing that you need to do is to launch Wampserver. Left click on the tray icon. Select MySql then click on the my.ini file. And open that up using any text editor:

image

The one that we need to change is obviously the port number:

image

Just change it to any number you want. As long as it is 2 to 5 digits long. And the port number should not be similar with any of the port numbers which are used by some of the applications which are installed on your system.

You need to download currports from nirsoft.net. Don’t worry because its absolutely free. And most of all, its portable so you don’t need to install anything.

The interface looks like this. And will give you an idea which application uses what port:

image

2 thoughts on “How to change MySql port

  1. Pingback: PHP Code suddenly doesn’t work? « Data Integrated Entity

  2. Pingback: How to configure rails to connect to mysql database « Data Integrated Entity

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s