How to change MySQL default port Windows?

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









Related Tutorials/Questions & Answers:
How to change default MySQL port in linux?
How to change MySQL default port Windows?
Advertisements
How to change MySQL default port Windows?
MySQL default port number and how to change it
MySQL Default Port number
MySQL default port number in Linux
how to change spring boot port number
Changing MySQL Port Number
What is the default session time in php and how can I change it?
what is redis default port number
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
Toedter JDateChooser JSpinner change day value by default in java
Mysql Date Default
Change root password of MYSQL using Java
Mysql Alter Column Default
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
prablems on oracle ee installation in windows7 ultimate(32 bit).
How to change functionlatiy in web page
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 change the checkbox value dynamically.
How to change object item to integer item
How to change the data in the table dynamically ?
How to change uploaded file root path ?
How to assign a default value to text box in netbeans
How to change color of opened Bootstrap drop down toggle?
how to change file from .txt to .mat(matrix)
how to change password into one jsp to another jsp
Change Local Repository
how to by default chceckbox button is selected in struts
How to configure mvc:default-servlet-handler tag?
How to change the cloth pattern, change the cloth pattern, cloth pattern
how to Change column name and Make a unique column.
How alter table in MySQL?
Getting the Local port
how to add date and change date in java - netbeans
ModuleNotFoundError: No module named 'port'
ModuleNotFoundError: No module named 'port-for'
How to change the color of a base64-encoded png image JQuery?
how to change div background color in javascript
How can I change UIButton title color?
how to change background color in dojo tab container - Framework
MySQL How to Topic

Ads