how do I know which ver of mysql i'm running?

kfiralfia · 04-01-2004, 08:39 PM

I just tried to upgrade from MySQL 3.23 to 4.0 on my Linux 7.3 server (using .rpm files from mysql.com). I think I managed to do it successfully, but I'm not sure how to determine which version of mysql my server is now running.

Is there a simple command that reveals this?

When I look at the phpinfo page on my test site (which spits out the results of php_info()), it says that the mysql Client API version is 3.23.58

Any ideas?

thanks!

kfiralfia · 04-01-2004, 09:14 PM

Figured it out...

at the mysql command line, type

SELECT VERSION();

turns out I really am running 4.0.18