Home Mysql MySQL default port number and how to change it
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

MySQL default port number and how to change it

Advertisement
Here is the default MySQL port number. It is very simple to change the default MySQL port number.

What is default port number of MySQL Database server?

This tutorial will explain you about the default port number used by the MySQL Server. This information is very important for you if you are working with MySQL Database server. This information will be useful if you have a requirement of connecting to MySQL database server by providing the port number in your program.

You can also change the port number of MySQL database server. Make sure your MySQL server is stopped. You should find the directory of MySQL installation and find the my.ini file. You can then edit the port number and change the value to desired number, finally save the file.

The MySQL default port number 3306.

Here are the steps to change the MySQL port number.

To change it follow the steps:

  1. Open "my.ini" file in MySQL server installation directory
  2. You will see the default port number "port=3306"
  3. Change it to desired port number.
  4. After changing, save the "my.ini" file
  5. Restart MySQL server

After restart MySQL will start listening to another port. If you have two instance of MySQL Server on the same machine then you can change the port number and run both the instance on the same machine.

Here more tutorials of MySQL:

Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: October 3, 2013

Ask Questions?    Discuss: MySQL default port number and how to change it  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
DMCA.com