List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:March 2 2011 11:31pm
Subject:Get MySQL server IP address in SQL
View as plain text  
Anyone knows how to get the server* IP address* thru SQL?

-- 
Claudio


*mysql> select * from GLOBAL_variables where variable_name like 'hostname';*
*+---------------+----------------+*
*| VARIABLE_NAME | VARIABLE_VALUE |*
*+---------------+----------------+*
*| HOSTNAME      | haarlemeer     |*
*+---------------+----------------+*
*1 row in set (0.01 sec**)*

*mysql> select * from GLOBAL_variables where variable_name like '%ip%';*
*+------------------------+----------------+*
*| VARIABLE_NAME          | VARIABLE_VALUE |*
*+------------------------+----------------+*
*| SSL_CIPHER             |                |*
*| SLAVE_SKIP_ERRORS      | OFF            |*
*| SKIP_SHOW_DATABASE     | OFF            |*
*| SKIP_NAME_RESOLVE      | OFF            |*
*| NAMED_PIPE             | OFF            |*
*| SKIP_NETWORKING        | OFF            |*
*| SQL_SLAVE_SKIP_COUNTER |                |*
*| SKIP_EXTERNAL_LOCKING  | ON             |*
*+------------------------+----------------+*
*8 rows in set (0.00 sec)*

Thread
Get MySQL server IP address in SQLClaudio Nanni3 Mar
  • Re: Get MySQL server IP address in SQLReindl Harald3 Mar
    • Re: Get MySQL server IP address in SQLChris W3 Mar
      • Re: Get MySQL server IP address in SQLSteve Staples3 Mar
        • Re: Get MySQL server IP address in SQLClaudio Nanni3 Mar
          • RE: Get MySQL server IP address in SQLJerry Schwartz3 Mar
            • Re: Get MySQL server IP address in SQLClaudio Nanni3 Mar