What version of MySQL do I have?

Databases
1

I’m trying to install Drupal, how do I find out what version of MySQL I have?

I don’t use a GUI Admin… I connect, apart from doing so with PHP and JSP, thru unix shell… (this is locally on my mac)
is there a command in command-line client to find out what version I have?

I went to MySQL folder where it’s installed but couldn’t find in there…

thank you…

oh man… NEVER MIND… it tells you when you log in… I had never noticed this… :wink:

2

I see you found the answer. Here’s another: Run the query “SHOW VARIABLES”, and look at the “version” line.

3

and another, from the mysql command prompt type
SELECT version()

4

I’m not sure where it’s documented, but like sql server, mysql supports select @@version