Verify Database Version
Author: Nedko Hristov
First, you can verify that MySQL is running by executing the following:
mysqladmin version
You should see something like this:
mysqladmin Ver 8.41 Distrib 4.1.12a, for Win32 on ia32
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.12a-nt
Protocol version 10
Connection localhost via TCP/IP
TCP port 3306
Uptime: 2 days 5 hours 35 min 14 sec
Threads: 6 Questions: 22984 Slow queries: 0 Opens: 1366 Flush tables: 1 Open tables: 4 Queries per second avg: 0.119
If the command is not recognized, MySQL's bin directory is not in your path so you have to either add it to the path or be in $MYSQL_HOME/bin where $MYSQL_HOME is the folder where MySQL is installed. If you still encounter an error, please verify that MySQL server is running and consult the manual for details.