From: Claudio Nanni
Date: March 2 2011 11:31pm
Subject: Get MySQL server IP address in SQL
List-Archive: http://lists.mysql.com/mysql/224556
Message-Id: <AANLkTikQ5kwz0iXVRxvNXoxxTME+hbDU_+A26Eg2xHNR@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=bcaec5014c511adb0a049d88507f

--bcaec5014c511adb0a049d88507f
Content-Type: text/plain; charset=ISO-8859-1

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)*

--bcaec5014c511adb0a049d88507f--