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?
Thanks,
Joshua Smith
--
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
