How to change MySQL default port Windows?

Ads
 

How to change MySQL default port Windows?

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

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









Related Tutorials/Questions & Answers:
How to change default MySQL port in linux?
How to change MySQL default port Windows?
Advertisements
MySQL default port number and how to change it
MySQL Default Port number
MySQL default port number in Linux
Changing MySQL Port Number
What is the default session time in php and how can I change it?
mysql port number other than 3306
Change port from 8080 to 80 in Apache tomcat - WebSevices
How to change image size before adding to mysql using jsp
Change Column Name in MySQL
Mysql Date Default
Mysql Alter Column Default
Toedter JDateChooser JSpinner change day value by default in java
Change root password of MYSQL using Java
How to change background, change background
How to change the face, change the face
Mysql Add Column Default Value
how to change color of titlebar in java
How to change functionlatiy in web page
How to assign a default value to text box in netbeans
How to configure mvc:default-servlet-handler tag?
dynamically how to change attiribute values in xml
How to change password mask field?
How to get xml file form http port using web service
how to by default chceckbox button is selected in struts
prablems on oracle ee installation in windows7 ultimate(32 bit).
How to change the checkbox value dynamically.
How alter table in MySQL?
How to change object item to integer item
How to change the data in the table dynamically ?

Ads