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