如何才能通过查询找到网络上的数据库ip位置？ （MySQL的）

Question

How can I found out the database ip location on network only with query? (mysql) I can debug with the query inside web application only.(add code of query that show db location inside executed function)

(I don't know with which db I working - on my computer or with db on other local network computer.)

ip on my computer for example : 10.0.0.07 and on other computer that also has same db 10.0.0.09

Thanks, Yosef

Answer 1

mysql> SELECT @@hostname;
+-----------------------+
| @@hostname            |
+-----------------------+
| localhost.localdomain | 
+-----------------------+
1 row in set (0.00 sec)

mysql> SHOW GLOBAL VARIABLES LIKE 'hostname';
+---------------+-----------------------+
| Variable_name | Value                 |
+---------------+-----------------------+
| hostname      | localhost.localdomain | 
+---------------+-----------------------+
1 row in set (0.00 sec)