Description:
The "Network Name" shown under the "Server Information" on the "Server Information" page of MySQL Administrator is unnecessary and misleading. Find below the "Server Information" when connecting to the same MySQL server from the same machine using different values for the "Server Hostname".
Connecting using "localhost"
-----------------------------
Connected to MySQL Server Instance
User:peter
Host:localhost
Socket:/var/lib/mysql/mysql.sock
Server Information
MySQL Version:MySQL 5.0.26
Network Name:localhost
IP:127.0.0.1
Connecting through "127.0.0.1"
-------------------------------
Connected to MySQL Server Instance
User:peter
Host:127.0.0.1
Port:3306
Server Information
MySQL Version:MySQL 5.0.26
Network Name:localhost
IP:127.0.0.1
Connecting through host name "Suse-10-2"
------------------------------
User:peter
Host:Suse-10-2
Port:3306
Server Information
MySQL Version:MySQL 5.0.26
Network Name:
IP:127.0.0.2
Connecting through 192.168.0.111
------------------------------
User:peter
Host:192.168.0.111
Socket:3306
Server Information
MySQL Version:MySQL 5.0.26
Network Name:
IP:192.168.0.111
When connecting via a socket isn't "Network Name:localhost" a bit misleading since there is no network connection?
No "Network Name" is displayed when connecting using an IP address or the actual host name.
Can't we do away with the "Network Name" altogether?
How to repeat:
See above.
Suggested fix:
See above.