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
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.