MySQL Forums
Forum List  »  MySQL Administrator

MySQL version information
Posted by: Shiva V
Date: December 21, 2011 01:36PM

Hi,

I am trying to gather information as what type of MySQL software is installed on a server here. Whether it is a community, standard or enterprise sort of. I am trying to get this info from the following ways but cannot tell what version it is...

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 24505698
Server version: 5.1.25-rc-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> show variables like '%version%';
+-------------------------+---------------------+
| Variable_name | Value |
+-------------------------+---------------------+
| protocol_version | 10 |
| version | 5.1.25-rc-log |
| version_comment | Source distribution |
| version_compile_machine | i386 |
| version_compile_os | pc-solaris2.10 |
+-------------------------+---------------------+


mysql> select version();
+---------------+
| version() |
+---------------+
| 5.1.25-rc-log |
+---------------+


I can tell from the above that it is a 5.1 version of MySQL but how to find if it is a Community,standard or enterprise edition? And also what does the "Source Distribution" mean in the version_comment? Does it mean it was installed using the source like rpm installation?

Thanks,
Shiva

Options: ReplyQuote


Subject
Written By
Posted
MySQL version information
December 21, 2011 01:36PM
January 07, 2012 10:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.