How to view mysql version in command prompt?

by Ramya 2008-05-29 10:11:27

To view mysql version in command prompt,
> Goto command prompt
> start mysql
> then type "mysql --version"
it displays the version of mysql as,
mysql Ver 14.12 Distrib 5.0.45, for Win32 (ia32)

To view mysql version in mysql prompt then use,
mysql>select version();
it displays,
+---------------------+
| version() |
+---------------------+
| 5.0.45-community-nt |
+---------------------+

Tagged in:

652
like
0
dislike
0
mail
flag

You must LOGIN to add comments