How to find on which port MySQL Server running on Windows Machine - MySQL DBA Tutorial

How to find on which port MySQL Server running on Windows Machine




There are multiple ways to find the port which MySQL Server is listening. If you are already connected to MySQL server and you want to check the port, you can run the below query.

show variables where variable_name in ('hostname','port');

Another way to find out the port which MySQL Server is using on Windows is , Go to my.ini file that is MySQL configuration  file and you can check the port.

To find the my.ini file for MySQL Server, you can go to services and then go to properties.
my.ini file location for MySQL Server in Windows

Once you know the location of my.ini file, open the .ini file and look for port.

Check my.ini file for MySQL Port on which it is listening in Windows


Check out the video to see details how to find the port on which MySQL Servers are running

3 comments: