How To Get Client IP Address Via MySQL Router
(Doc ID 2798373.1)
Last updated on AUGUST 10, 2021
Applies to:MySQL Router - Version 8.0 and later
Information in this document applies to any platform.
When a client host connects to a MySQL server via a MySQL router, the "Host" column in SHOW PROCESSLIST statement, INFORMATION_SCHEMA PROCESSLIST table or PERFORMANCE_SCHEMA PROCESSLIST table can only show the host name/IP address of the router.
This document introduces a method to get the real client host IP address via MySQL Router 8.0.23 or later.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document