What Is Default MySQL Port Number? [MySQL Server Port]
Do you know what’s the default SQL Port number that is used to access MySQL Database is? This article will brief you about what is MySQL Port and the Default MySQL server post.
List of content you will read in this article:
- 1. What is Default MySQL Port Number?
- 2. Check MySQL Port Number Used by MySQL Server
- 3. How to Change Default MySQL Port Number?
- 4. Various MySQL Ports
- 5. Take Away
MySQL is a database management system used in a network to add, access, and process the data stored in a database. To connect directly or access your MySQL database or connect a different application to the database, you should have information such as the MySQL port number. Inside this article, you will get detailed information about the default Mysql port number and what it is, and how to change default MySQL port.
What is Default MySQL Port Number?
For your database, the default MySQL port number is 3306. While most applications will set the port number by default, in other cases, it may change. The port number may also change for security purposes. It may also change because another application already uses the database port number.
The MySQL protocol uses the default port to connect to utilities such as ‘mysqldump’ and MySQL clients.
Are there vulnerabilities when using the port?
The MySQL server is vulnerable to attacks when the default port 3306 is opened. Thus, the user has to explore other secure options if they want to access the database remotely.
Instead of using the default port, consider options like an SSH tunnel. The other option is restricting the IP addresses that can access the port to prevent connection by suspicious hosts. It doesn’t mean that MySQL will always use it. Running a short SQL query can help you identify the port your MySQL is running on.
Check MySQL Port Number Used by MySQL Server
You might find that one to even ten ports are used in your MySQL ecosystem. The port in use is essentially determined by the components in use, what has been enabled, how your apps connect, and the general characteristics of the MySQL environment.
The ideal way to use the ports is to make them wide enough to accommodate the different components while at the same time blocking out untrustworthy hosts.
There are several ways to establish the port your MySQL server listens to. If you are connected to your MySQL server, you can run the query «show variables where variable name in (‘hostname,’ ‘port’).»
If you are using Windows, you can check the MySQL port number in the configuration file.
Here are the steps.
Step 1: Go to «my.ini file»
Step 2: Open the «Services» window and find properties; then, you will find the location of the my.ini file.
Step 3: Open the .ini file
After finding the file’s location, find the MySQL port that is listening in Windows.
How to Change Default MySQL Port Number?
Changing your default MySQL port can protect you from unauthorized access through brute-force scripts. While non-standard ports may enhance your security, it only extends the time it takes for successful hacking to go through. Therefore, it would help if you had other security measures in place.
You may also require a port change if the standard 3306 is busy.
You can change the default port number of your MySQL server by following the below-listed steps.
Step 1: Open the «my.ini» file in the MySQL installation directory
Step 2: You will see the port with the default number 3306
Step 3: Change the port number 3306 to your desired number
Step 4: Save the changes so that the «my.ini» file is saved
Step 5: Restart your MySQL server so that it picks the changes.
You can then open the «my.ini» file in the server’s installation directory. When you restart MySQL, it will start listening to the new port number.
Various MySQL Ports
MySQL Port awareness is critical as it helps you understand when they will be used.
1. Port 3306/TCP
The default port 3306 connects MySQL clients to the MySQL server. The communication on this port is also encrypted by default. The direction of communication on this port is from the client to the server and is required unless X protocol is used.
2. Port 33060/TCP
Communication from this port is from the MySQL client to the server and is also encrypted. The port is also necessary for communication unless the default 3306 is being used.
3. Port 33062/TCP (default)
The communication on the port is from the client to the server and is also encrypted. Note that this MySQL port is particularly configured to support administrative connections. The administrative interface of MySQL makes it for operations like the administration of users, configuration of servers, viewing logs, and exports and imports.
4. Port 33061/TCP
33061/TCP alongside 33060/TCP and 3306/TCP are categorized as shell ports. Port 33061/TCP is required for running InnoDB Cluster. The communication on the port is also encrypted. The port’s key role is to check a server during the configuration of the InnoDB Cluster.
5. Port 22/TCP
MySQL workbench integrates administration, database design, maintenance, creation, and SQL development. The visual database design tool integrates all the said elements into a single development environment in the database system.
Port 22/TCP is a workbench port whose direction of communication is from the MySQL workbench to the server. Communication rides on a connection through an SSH tunnel.
Take Away
Being aware of the different MySQL ports is important. You need to understand what they are, who uses them, what uses them, when the ports should be used, level of security in terms of encryption and access limitations. This is the best information we have given about MySQL port, default MySQL port number, and various port no of MySQL. Suggest your feedback via below given comment box.
People also read:
Tutorials
I’m fascinated by the IT world and how the 1’s and 0’s work. While I venture into the world of Technology, I try to share what I know in the simplest way with you. Not a fan of coffee, a travel addict, and a self-accredited ‘master chef’.
How do I find out my MySQL URL, host, port and username?
I need to find my MySQL username. When I open the MySQL command line client, it only asks me for my password. I don’t remember my username. And for connectivity with JDBC, I need the URL, host and port number. Where do I find all of these?
12 Answers 12
If you’re already logged into the command line client try this:
It will output something similar to this:
In my example above, I was logged in as root from localhost .
To find port number and other interesting settings use this command:
If you want to know the port number of your local host on which Mysql is running you can use this query on MySQL Command line client —
It will give you the port number on which MySQL is running.
If you want to know the hostname of your Mysql you can use this query on MySQL Command line client —
It will give you the hostname for mysql.
If you want to know the username of your Mysql you can use this query on MySQL Command line client —
It will give you the username for mysql.
For example, you can try:
If you don’t know the exact variable name use like , as the result may contain more than 500 rows:
If using MySQL Workbench, simply look in the Session tab in the Information pane located in the sidebar.
Easiest way is probably using command status; In the output you’ll find database, user, host and port:
If you use phpMyAdmin, click on Home , then Variables on the top menu. Look for the port setting on the page. The value it is set to is the port your MySQL server is running on.
Here are the default settings
default-username is root
default-password is null/empty //mean nothing
default-url is localhost or 127.0.0.1 for apache and
localhost/phpmyadmin for mysql // if you are using xampp/wamp/mamp
default-port = 3306
For Example in my case : karola-pc is the host name of the box where my mysql is running. And it my local PC host name.
If it is romote box than you can ping that host directly if, If you are in network with that box you should be able to ping that host.
If it UNIX or Linux you can run «hostname» command in terminal to check the host name. if it is windows you can see same value in MyComputer-> right click -> properties ->Computer Name you can see ( i.e System Properties)
How to check what port mysql is running on
How can I check what port it is running on the unix server that I have to upload the app to.
10 Answers 10
mysql> SHOW GLOBAL VARIABLES LIKE ‘PORT’;
And that indicated that I was using port 3306 and that my search for the error continues.
The best way to actually know what application is listening to which interface and on what port is to use netstat
You can do this as root:
It will list out all the listening services like this:
The last column shows you that mysqld bound itself to port 3306 listening on all interfaces.
In fact, this works for everything, not just mysql. You can also use it non TCP sockets.
MySQL Default Port
By 
Payal Udhani
Introduction to MySQL Default Port
MySQL Ports are one kind of mechanism in network protocols that allows the server to handle and manage multiple client’s connections and sessions in a particular network. The default port of MySQL is 3306. The port is represented and identified by a numerical value of 2 bytes that is 16 bits in size. Out of them, 65536 port numbers are named ports that are further classified based on the protocol used for transport as TCP or UDP ports.
There are four types of protocol values namely, TCP used in all operating systems, PIPE, and MEMORY used in the Windows operating system and SOCKET that are used in Unix/Linux operating systems. All these protocol values are used for establishing and maintaining the connection to a remote or local server. In MySQL TCP/IP sockets are used to connect with the clients that are situated remotely.
Hadoop, Data Science, Statistics & others
In this article, we will see how the ports currently being used are retrieved and how to check your MySQL port and connect with the MySQL database server using your default MySQL port and how we can change the default port used to connect to MySQL using the configuration file.
Checking the MySQL port you are using
When you are connected to the MySQL server and you want to check the port that is being used by your client to connect with MySQL server, you can retrieve the value of the variable named port that stores the port number used for the connection. This can be done in the following way –
SHOW VARIABLES LIKE ‘port’;
You can use the above command in Unix/Linux platforms and get to know the port number being used to connect to the MySQL server. In our case, the output is as follows –
We can see that the value of the port variable is 3306. This is the default value of the MySQL port number.
In windows, the following command is used to get to know the value of MySQL port.
Mysql -u your_username -e “SHOW GLOBAL VARIABLES LIKE ‘PORT’”
Mysql database is accessed by multiple clients and users and this leads to the creation of multiple connections and sessions. All these are supported by MySQL that uses TCP/IP socket, Named pipes, or Unix sockets to connect with the network. The remote connections are always made using TCP/IP sockets and 3306 as the default port number of Mysql.
To check the port of MySQL on our network in Unix/Linux platforms, we can make the use of the following command –
netstat -a |grep mysql;
that gives the following output in my case –
it tells us that there are 2 connected connections of MySQL and one connection is listening. In the above command, netstat is used to display the status of the net and -a stands for all the connections while | operator is used to specifying the filters and additional information. In our case, we are using grep that states to search with keyword “mysql” specified further.
Alternatively, you can use the following command –
netstat -na |grep 3306;
that gives following output –
In windows, you can make the use of the following query –
netstat -na | find “3306”
that will display all connections with 3306 port. The output indicates that the port with port number 3306 is listening at localhost 127.0.0.1 address and uses TCP socket and protocol for connection.
Connecting to Mysql database server
We can connect to our MySQL database server using the command-line terminal with the help of TCP/IP protocol connection by connecting to a specific port that is listening to the network connections as we saw in the output of the above command that 3306 port is listening. The command used to connect to the database server using its default port and root access is as follows –
that gives the following output –
By specifying the particular port using which you want to establish the TCP/IP connection to the MySQL database server, you can use the following command –
mysql -u root –port=3306
that gives following output –
For both these commands, we had to first log in as a superuser using su command.
In this way, we can connect to the MySQL database server by using the command-line on any platform.
Changing the default port of MySQL
Now, we will see where the default port of MySQL is configured and specified and how we can change it to any other port we want. The information about the MySQL configurations is stored inside the my.ini of my.cnf file. This file is present in the folder where your database is installed. It is very easy to change the port. All we have to do is to change the settings of the file.
Depending on which MySQL server package is installed on your machine the extension of the file may change but it will always be either ini or cnf with the name my or mysql.cnf or mysqld.cnf. In my case, this file is located here –
and it contains the following things –
It can be seen that online number 34 in my case the file contains a variable named port that has value 3306 specified as follows –
To change the default port, all we have to do is to change the value of the 3306 to the port number that you wish your MySQL database server to listen to and then save the file. Built before this, it is necessary to the execution of the MySQL service that is currently running using the following query –
service MySQL stop
in unix/linux platform and
for windows platform.
Then open the configuration file. Suppose, we want to change the port to 4000 instead of 3306 as default port then we will change the port value to 4000 in the configuration file as shown below and save this file.
If the file is in the read-only mode, firstly change the privileges by either using the chmod command or changing the properties and then save the file.
Then restart the MySQL service by using
service mysql start
in Unix/Linux platform and
for windows platform.
Conclusion
Mysql has the default port number 3306 assigned to it where the server listens for client connection establishment. It can be further configured and changed by changing the port variable value in the configuration file.
Recommended Articles
This is a guide to MySQL Default Port. Here we discuss how the ports currently being used are retrieved and how to check your MySQL port. You may also have a look at the following articles to learn more –