Example method to view the IP address connected to MySQL

Specific method:

First open the command prompt;

Then execute the [ mysql -u root -p ] command to enter mysql;

Finally, execute the following command:

select SUBSTRING_INDEX(host,':',1) as ip , count(*) from information_schema.processlist group by ip;

This is the end of this article about the example method of checking the IP address of MySQL. For more information about how to check the IP address of MySQL, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope you will support 123WORDPRESS.COM in the future!