"Neeraj Vasudeva" <[EMAIL PROTECTED]> wrote: > > I have loaded MYSQL Version 4.0.12, and also loaded MySQL Control Centre > 0.8.10-beta, on Win 98 > > Now when i go to command prompt and issue the command as > > mysql> show processlist; > > +----+------+----------------+-------+---------+------+-------+------------------+ > | Id | User | Host | db | Command | Time | State | Info | > +----+------+----------------+-------+---------+------+-------+------------------+ > | 2 | ODBC | 127.0.0.1:1046 | NULL | Sleep | 8 | | NULL | > | 7 | root | 127.0.0.1:1056 | mysql | Sleep | 460 | | NULL | > | 8 | root | 127.0.0.1:1058 | NULL | Sleep | 459 | | NULL | > | 10 | ODBC | 127.0.0.1:1060 | NULL | Query | 0 | NULL | show processlist | > +----+------+----------------+-------+---------+------+-------+------------------+ > 4 rows in set (0.00 sec) > > so i can see my ip is diplayed as 127.0.0.1 but when i use MySQL GUI Control Centre > it displays my actual ip which is configured in network neighbourhood or TCP/IP > settings of Windows 98 > i.e. 10.170.1.184 > > why is this discrepency, i think it should show my ip 10.170.1.184 on command prompt > also when > i issue command show processlist;
There was a bug in SHOW PROCESSLIST in this version of MySQL. The bug was fixed in 4.0.13. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
