Brian Cryer

Cry MySQL How to...

Determine which version of MySQL you are connected to

To determine which version of MySQL you are connected to, use the following SQL:

select version();

This will return a single result (for example "4.0.16-nt") containing the MySQL version number.

These notes have been tested against MySQL version 4 and 5.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.