MySQL

295 guides

keyboard_arrow_down

Other math topics

Dagster

Pandas

NumPy

Matplotlib

PySpark

MySQL

chevron_leftGetting started

'mysql' command not found Checking version in MySQL Closing a MySQL session Comments in MySQL Connecting to the MySQL Server Installing MySQL Setting up a MySQL Server

check_circle

Mark as learned

thumb_up

thumb_down

chat_bubble_outline

Comment

auto_stories Bi-column layout

settings

Checking version in MySQL

schedule Aug 10, 2023

Last updated

local_offer

MySQL

Tags

tocTable of Contents

expand_more

mode_heat

Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!

In your terminal, type in the following command:


        
        
            
                
                
                    mysql --version

Note that the following will not work:

If you are connected to the MySQL server, then use the following:


        
        
            
                
                
                    mysql> SHOW VARIABLES LIKE "%version%";
                
            
            +--------------------------+-------------------------------+
| Variable_name            | Value                         |
+--------------------------+-------------------------------+
| immediate_server_version | 999999                        |
| innodb_version           | 8.0.19                        |
| original_server_version  | 999999                        |
| protocol_version         | 10                            |
| slave_type_conversions   |                               |
| tls_version              | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 |
| version                  | 8.0.19                        |
| version_comment          | MySQL Community Server - GPL  |
| version_compile_machine  | x86_64                        |
| version_compile_os       | macos10.15                    |
| version_compile_zlib     | 1.2.11                        |
+--------------------------+-------------------------------+

Published by Arthur Yanagisawa

Edited by 0 others

Did you find this page useful?

thumb_up

thumb_down

Comment

Citation

Ask a question or leave a feedback...

thumb_up

thumb_down

chat_bubble_outline

settings

Enjoy our search

Hit / to insta-search docs and recipes!