Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (20.3k points)

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.

1 Answer

0 votes
by (40.4k points)

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

Related questions

0 votes
1 answer
0 votes
1 answer
asked Jul 11, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
0 votes
1 answer
asked Jul 20, 2019 in SQL by Tech4ever (20.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...