-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Josh Smith wrote:
> Hello, all.
>
> I have noticed over the last few days that when I do a SHOW
PROCESSLIST on my MySQL server the host field always reports the same
host IP address or name regardless of who is making the connection.
Here is a run of the command on my machine:
>
> mysql> show processlist;
>
>
+-----+---------------+----------------+-------------+---------+------+-------+------------------+
> | Id | User | Host | db | Command | Time
| State | Info |
>
+-----+---------------+----------------+-------------+---------+------+-------+------------------+
> | 334 | engineer | 127.0.0.1:1164 | engineering | Sleep | 235
| | NULL |
> | 335 | processviewer | 127.0.0.1:1313 | NULL | Sleep | 0
| | NULL |
> | 336 | root | 127.0.0.1:1316 | NULL | Query | 0
| NULL | show processlist |
>
+-----+---------------+----------------+-------------+---------+------+-------+------------------+
> 3 rows in set (0.00 sec)
>
> The user 'engineering' is not connecting from my local machine but the
other two are. The port for the engineer user is correct according to
netstat. The server is running on my development machine which runs
Windows 2000 Professional. The server is the standard Win32 binary
4.0.12-nt-log.
>
> Has anyone else seen this phenomenon?
Yes. It was fixed in 4.0.13 (which is the latest STABLE release) :)
-Mark
- --
For technical support contracts, visit https://order.mysql.com/?ref=mmma
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows
/_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
<___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+4KSbtvXNTca6JD8RAo9WAKCaPmpbGzsz8650JdfpJXrJcIeigACfXYJV
NToY2vwgYSGO6yZ6TZP0ORY=
=s2e8
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
