My Oracle Support Banner

How To Get Client IP Address Via MySQL Router (Doc ID 2798373.1)

Last updated on APRIL 18, 2023

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.