Help Center> Relational Database Service> FAQs> Database Connection> How Do I View All IP Addresses Connected to a Database?
View PDF

How Do I View All IP Addresses Connected to a Database?

You can run the following SQL statement on the database to query the number of connected IP addresses:

SELECT substring_index(host, ':',1) AS host_name,state,count(*) FROM information_schema.processlist GROUP BY state,host_name;

Parent topic: Database Connection