What IP address is mySQL listening on?
mySQL | Explination | SQL Server |
From a command line: mysql -u username -p -e "SHOW GLOBAL VARIABLES like 'bind_address'" | Displays the IP the server is listening on | You 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