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
Mua vé tại Aivivu, tham khảo
ReplyDeletevé máy bay đi Mỹ giá rẻ 2021
vé máy bay từ mỹ về việt nam hãng ana
chuyến bay từ đức về hà nội hôm nay
đặt vé máy bay từ nga về việt nam
giá thuê máy bay từ anh về việt nam
chuyến bay từ Paris về Hà Nội
khách sạn cách ly
I so much love this blog
ReplyDeleteAs for the MySQL database, I can recommend a good tool - dotconnect for mysql
ReplyDelete