Hello mysql, We make updade of database from 3.23.49 to 4.0.12 Before update we can see host of connections /see Example1/. After update every connections looks like they made from local host /see Example2/, but they did not. Any explanation of effect?!?
Example1: mysql> show processlist; +---------+------------+------------------------------------+-----------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+------------+------------------------------------+-----------+---------+------+-------+------------------+ | 1037596 | authengine | local.lozenec-sf.link.noc.sf.panda | squidauth | Sleep | 7081 | | NULL | | 1037597 | authengine | local.lozenec-sf.link.noc.sf.panda | squidauth | Sleep | 7081 | | NULL | | 1037622 | authengine | peer.hq.link.noc.sf.panda | squidauth | Sleep | 6751 | | NULL | | 1038112 | root | localhost | NULL | Query | 0 | NULL | show processlist | +---------+------------+------------------------------------+-----------+---------+------+-------+------------------+ 4 rows in set (0.00 sec) Your MySQL connection id is ...... to server version: 3.23.49 Example2: mysql> show processlist; +----+-----------+----------------+------+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +----+-----------+----------------+------+---------+------+-------+------------------+ | 1 | pbxengine | localhost:2277 | pbx | Sleep | 66 | | NULL | | 2 | pbxengine | localhost:3188 | pbx | Sleep | 40 | | NULL | | 3 | pbxengine | localhost:1337 | pbx | Sleep | 213 | | NULL | | 11 | pbxengine | localhost:2833 | pbx | Sleep | 309 | | NULL | | 57 | root | localhost | NULL | Query | 0 | NULL | show processlist | +----+-----------+----------------+------+---------+------+-------+------------------+ 5 rows in set (0.01 sec) Your MySQL connection id is .... to server version: 4.0.12 -- Best regards, PandaCoop-Krasimir_Slaveykov mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
