# For MySql" Show Processlist" host name shows like '%.5462' not able to get this?

**URL:** <https://forums.percona.com/t/for-mysql-show-processlist-host-name-shows-like-5462-not-able-to-get-this/8386>\
**Category:** Percona Server for MySQL\
**Created:** [December 13, 2020, 2:56am UTC](https://forums.percona.com/t/for-mysql-show-processlist-host-name-shows-like-5462-not-able-to-get-this/8386 "2020-12-13T02:56:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lokesh123](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lokesh123/32/5519_2.png) [@lokesh123](https://forums.percona.com/u/lokesh123)\
**Post date:** [December 13, 2020, 2:56am UTC](https://forums.percona.com/t/for-mysql-show-processlist-host-name-shows-like-5462-not-able-to-get-this/8386/1 "2020-12-13T02:56:03Z")

</div>

[Capture.PNG](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/b86708535665333e34aba2258bc514cbe0fc88b0.png)

When I run my procedure with different user with definer

"show processlist " in host name I got ‘%’ with some ports.

eg.

id user host

16 root %:31514

Any suggestion.

![Capture.PNG](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/b86708535665333e34aba2258bc514cbe0fc88b0.png)

---

<div class="post-metadata">

**Author:** ![Agustin\_G](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/agustin_g/32/14111_2.png) [@Agustin\_G](https://forums.percona.com/u/Agustin_G)\
**Post date:** [December 15, 2020, 5:49pm UTC](https://forums.percona.com/t/for-mysql-show-processlist-host-name-shows-like-5462-not-able-to-get-this/8386/2 "2020-12-15T17:49:23Z")

</div>

Hi,

Can you send the procedure you are using, and steps to reproduce? Do you get correct IP addresses if you call the procedure with the same user as the definer?

Also, what exact version are you using?

SHOW VARIABLES LIKE ‘ver%’;

---

<div class="post-metadata">

**Author:** ![lokesh123](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lokesh123/32/5519_2.png) [@lokesh123](https://forums.percona.com/u/lokesh123)\
**Post date:** [January 14, 2021, 9:51am UTC](https://forums.percona.com/t/for-mysql-show-processlist-host-name-shows-like-5462-not-able-to-get-this/8386/3 "2021-01-14T09:51:38Z")

</div>

@Agustin_G Thanks for the response.

Reproduce:  
When I run/execute a procedure which have definer as ‘root’ from another users it shows same.

MySQL version 8.0.22.
