My Oracle Support Banner

How To Identify Client Hosts Connected via MySQL Router (Doc ID 2985858.1)

Last updated on NOVEMBER 09, 2023

Applies to:

MySQL Router - Version 8.0 and later
Information in this document applies to any platform.

Goal

 As written in <Document 2487438.1>, MySQL Server uses the host name where MySQL Router is running for authentication if clients connect via MySQL Router. The MySQL Router host names are also used in SHOW PROCESSLIST output; it is not possible to identify the actual client hosts for connections via MySQL Router. This document describes how to identify the actual client hosts when clients connect via MySQL Router.
 

Solution

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
Goal
Solution
References


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