Monday, December 7, 2020

mySQL: What IP are you listening on?

 What IP address is mySQL listening on?

mySQLExplinationSQL Server
From a command line:
mysql -u username -p -e "SHOW GLOBAL VARIABLES like 'bind_address'"
Displays the IP the server is listening onYou can use SQL Server Configuration Manager to make changes to the networking stack
OR
If you can get a connection to the server, you can what it's already listening to/on/for:

SELECT distinct local_tcp_port,net_transport,protocol_type,auth_scheme FROM sys.dm_exec_connections where client_net_address <> '<local machine>'





No comments:

Post a Comment