Show MySQL host via SQL Command

Question

Show Database

Use database

show tables

Describe <table>

All good and well, but is it possible to show the current connections host. Not connection_id, but the IP Address or Name of the host.

Answer 1

Use the code given below, to get the current hostname:

select @@hostname;

show variables where Variable_name like '%host%';

Try the below code, to get hosts for all incoming requests:-

select host from information_schema.processlist;

In mysql document mention this:

resolveip google.com.sg

To resolve IP for the hostname using pure MySQL function, as it is required for a network lookup, refer to this document:

http://dev.mysql.com/doc/refman/5.0/en/resolveip.html