Is there a direct command line command that provides all mysql server information like below...This is provided using Mysql GUI administrator. Do we have some direct command to get this info ussing command line ?
Username:
Hostname:
Port:
Server Information
MySQL Version:
Network Name:
IP:
Client Information
Version:
Network name:
IP:
Operating System:
Hardware:
Look at following MySQL documentation:
Following command will show you most of your desired information:
SHOW VARIABLES;
Only version:
select version();
EDIT:
What is the difference between show variables and show status?
SHOW STATUS provides server status information like Connections, Opened_tables, Bytes_received, Bytes_sent, etc.
SHOW VARIABLES shows the values of MySQL system variables like time_zone, version, max_connections, etc.