How to check the MySql version

Posted on Posted in MySql, Programming, Uncategorized

Create a query with:

SHOW VARIABLES LIKE "%version%";

Result is similar to:

Variable_name            Value                         
-----------------------  ------------------------------
innodb_version           5.6.35                        
protocol_version         10                            
slave_type_conversions                                 
version                  5.6.35-log                    
version_comment          MySQL Community Server (GPL)  
version_compile_machine  x86_64                        
version_compile_os       Win64