Changing MySQL Port Number

Changing MySQL Port Number

How to change the MySQL port no in windows.

View Answers

January 10, 2013 at 10:11 PM

Hi,

Open the my.ini file present in the MySQL server installation directory. Change the port number to desired port number.

By default port no entry will look like:

port=3306

You can change the value of port to the desired port number.

After making change in my.ini file save the file and then restart mysql server.

Thanks









Related Tutorials/Questions & Answers:
Changing MySQL Port Number
Changing MySQL Port Number  How to change the MySQL port... installation directory. Change the port number to desired port number. By default port... to the desired port number. After making change in my.ini file save the file
MySQL Default Port number
MySQL Default Port number  HI, What is MySQL Default Port number? Thanks   Hello, MySQL Server Default Port number is 3306. Thanks
Advertisements
MySQL default port number and how to change it
MySQL default port number and how to change it What is default port number... the port number in your program. You can also change the port number of MySQL... of MySQL server and how to change it?" The MySQL default port number
mysql port number other than 3306
mysql port number other than 3306  Hi, Can I change MySQL port number? What can be mysql port number other than 3306? Thanks
MySQL default port number in Linux
MySQL default port number in Linux - How to find the default port number... of MySQL in Linux?". After find the port number you can connect... number of MySQL server: mysql> show variables like 'port
port number - JavaMail
port number  i want james2.1.3 port number like microsoft telnet>open local host _______(some port number) i wnat that port number
mapr drill port number
mapr drill port number  Hi, What is the port number in Mapr for accessing Apache drill? I want to know all the mapr drill port numbers. Thanks   Hi, Here is the list of all the port of drill in mapr: Port Type
mapr drill port number
mapr drill port number  Hi, What is the port number in Mapr for accessing Apache drill? I want to know all the mapr drill port numbers. Thanks   Hi, Here is the list of all the port of drill in mapr: Port Type
what is redis default port number
in Python to connect to redis server and add/update data. I want to know the port number on which redis is running. Please help me in finding the default port number of redis. what is redis default port number? Thanks   Hi, Redis
How to change MySQL default port Windows?
, In windows MySQL database server stores port number information in my.ini file... tutorials of MySQL Server: MySQL Tutorials MySQL default port number and how...How to change MySQL default port Windows?  Hi, I am learning JDBC
How to change MySQL default port Windows?
, In windows MySQL database server stores port number information in my.ini file... tutorials of MySQL Server: MySQL Tutorials MySQL default port number and how...How to change MySQL default port Windows?  Hi, I am learning JDBC
how to change spring boot port number
developed in Spring boot which is running on port number 8080. I have to change the port number of the application to say 8084. How I can change the spring boot... server running on port number 8084? Provide me easy steps to do the same. Thanks
How to change default MySQL port in linux?
How to change default MySQL port in linux?  I have a sever and due to some reasons I want to run the MySQL server on the different port and not on the detault port 3306. How to change the MySQL default port on my Linux box
Mysql Date to Number
Mysql Date to Number      .... Now this tutorial illustrate an example for  Mysql Date to Number. To grasp this example, we use the given Mysql Query that return you the Date to Number
Mysql Phone Number Format
Mysql Phone Number Format       Mysql Phone Number Format is useful when you want to return... The Tutorial illustrate an example from 'Mysql Phone Number Format
how to auto generate number in jsp with the database connection mysql for employee number?
how to auto generate number in jsp with the database connection mysql for employee number?  how to auto generate number in jsp with the database connection mysql for employee number?   <%@page import="java.sql.
how to auto generate number in jsp with the database connection mysql for employee number?
how to auto generate number in jsp with the database connection mysql for employee number?  how to auto generate number in jsp with the database connection mysql for employee number?   <%@page import="java.sql.
Mysql Add Column Number
Mysql Add Column Number       Mysql Add Column Number is used to add the column to the existing table... 'Mysql Add Column Number'.To understand and grasp this example we create
Low port Scanner
Low port Scanner       In this section, you will learn how to get local port number... the massage on the command line very low port information. The java.net package
MySQL Creating account and changing password
MySQL Creating account and changing password       This MySQL provide the new creating account... to create new password.  Mysql as the intended username and the group
Changing root Password
Changing root Password  how do i change the root password in mysql
MySQL random number
MySQL random number      ... create a random number by the use of RAND() function of MySQL. There are two... in this example we will describe, how you can create random number in MySQL
VoIP Keep Your Number
;    VoIP Keep Your Existing Phone Number Changing your... the number port process, we provide you a temporary number so that you can begin... to depend on your former phone company while the port takes place. When your number
changing of data...
servlet.database is not changing in 10 second  hi.... i have created a servlet page using a response.setheader(); method.in the parameter i have... this servlet.database is not changing in 10 second...what should i do..?? reply fast
changing of data...
data changing in 10 second  hi.... i have created a servlet page using a response.setheader(); method.in the parameter i have given 10 second.but... is not changing in 10 second...what should i do..?? reply fast
changing of data...
changing of data...  hi.... i have created a servlet page using a response.setheader(); method.in the parameter i have given 10 second.but once... is not changing in 10 second...what should i do..?? reply fast
Local Port Scanner
of  java.net package which takes local port number as argument. A server... Local Port Scanner      ...;for (int port = 1; port < 500; port
ModuleNotFoundError: No module named 'port'
ModuleNotFoundError: No module named 'port'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'port' How to remove the ModuleNotFoundError: No module named 'port' error
ModuleNotFoundError: No module named 'port-for'
ModuleNotFoundError: No module named 'port-for'  Hi, My Python... 'port-for' How to remove the ModuleNotFoundError: No module named 'port... to install padas library. You can install port-for python with following
Listening port 8080
Listening port 8080  I need a java code through which i can listen the http port 8080 ... i want to interpret the incoming http request on 8080 port. Please help
changing uiview background color
changing uiview background color  changing UIView background color in ios   self.view.backgroundColor = [UIColor colorWithRed:244.0f/255.0f green:230.0f/255.0f blue:183.0f/255.0f alpha:1.0f
What is parallel port
What is parallel port  What is parallel port and its used for what
port 8080 already used
port 8080 already used  Error Server failed to start for port 8080: Address already in use: JVM_Bind   It just means that your port is being used. So the solution is to free the port. There is a small softeare (just
Changing 2D graph using slider.
Changing 2D graph using slider.  Code for changing a 2d graph with help of slider
Changing pictures - Java Beginners
Changing pictures  I found some html code that allows pictures to be changed on a web page. I copied the code and saved it as an html file. when I... Explorer that have pictures changing on them and they do not get blocked? 
changing primary key of parent table
changing primary key of parent table  I want to change one primary key from a table where primary key is auto created? How can I do that? I have... to your MySQL server version for the right syntax to use near 'upate person set
Setting source port on a Java Socket?
Setting source port on a Java Socket?  Is it possible to explicitly set the the source port on a Java Socket
changing selection color of <button>
changing selection color of   dear all, i have loaded image in border less button tag when button is selected with tab key i get brown color rectangle around image. how do i change color of that rectangle from brown to white
changing the file content
changing the file content  I have requirement like this, a file contain maximum 1000 lines. I want to cahnage the 501 line content. I know this logic , reading the file content and changeing the 501 line content and crating one
MySQL Round
MySQL Round       ROUND() function of MySQL rounds the number to the upwards or downwards to the nearest whole number or to the specified decimal places. For getting the whole
ModuleNotFoundError: No module named 'brioa-port'
ModuleNotFoundError: No module named 'brioa-port'  Hi, My Python... 'brioa-port' How to remove the ModuleNotFoundError: No module named 'brioa-port' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'port-range'
ModuleNotFoundError: No module named 'port-range'  Hi, My Python... 'port-range' How to remove the ModuleNotFoundError: No module named 'port... have to install padas library. You can install port-range python
ModuleNotFoundError: No module named 'brioa-port'
ModuleNotFoundError: No module named 'brioa-port'  Hi, My Python... 'brioa-port' How to remove the ModuleNotFoundError: No module named 'brioa-port' error? Thanks   Hi, In your python environment you
ModuleNotFoundError: No module named 'port-checker'
ModuleNotFoundError: No module named 'port-checker'  Hi, My Python... 'port-checker' How to remove the ModuleNotFoundError: No module named 'port-checker' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'port-eye'
ModuleNotFoundError: No module named 'port-eye'  Hi, My Python... 'port-eye' How to remove the ModuleNotFoundError: No module named 'port-eye... to install padas library. You can install port-eye python with following
ModuleNotFoundError: No module named 'port_killer'
ModuleNotFoundError: No module named 'port_killer'  Hi, My Python... 'port_killer' How to remove the ModuleNotFoundError: No module named 'port_killer' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'port-linker'
ModuleNotFoundError: No module named 'port-linker'  Hi, My Python... 'port-linker' How to remove the ModuleNotFoundError: No module named 'port-linker' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'port-scanner'
ModuleNotFoundError: No module named 'port-scanner'  Hi, My Python... 'port-scanner' How to remove the ModuleNotFoundError: No module named 'port-scanner' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'wait_for_port'
ModuleNotFoundError: No module named 'wait_for_port'  Hi, My... 'wait_for_port' How to remove the ModuleNotFoundError: No module named 'wait_for_port' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'get-port'
ModuleNotFoundError: No module named 'get-port'  Hi, My Python...-port' How to remove the ModuleNotFoundError: No module named 'get-port... to install padas library. You can install get-port python with following

Ads