How to change MySQL default port Windows?

 
 

Share on Google+Share on Google+

Java Coder
How to change MySQL default port Windows?
2 Answer(s)      a month and 10 days ago
Posted in : JDBC

Hi,

I am learning JDBC and installed MySQL. Now I want to change the default port 3306 to say 3307 of MySQL.

How to change MySQL default port Windows?

Thanks

Ads
View Answers

October 15, 2017 at 9:08 AM


Hi,

In windows MySQL database server stores port number information in my.ini file.

The my.ini file is present in the MySQL server installation directory.

So, to change the port from 3306 to 3307 you have to modify my.ini file.

Find your MySQL server installation directory and then search for my.ini file there.

Open this file in text editor and then update the port number 3306 to 33.7, save file and restart MySQL server.

Now your MySQL server listen on 3307 port.

Following video tutorial explains you the process:

Thanks



October 15, 2017 at 9:11 AM



Ads









Ads

 
Advertisement null

Ads