Mysql Workbench Select

In this tutorial I will explain how to check MySQL version number in different ways. MySQL provides some features for particular version numbers and on particular platforms only. So, in some situations it gets really important to find the MySQL version number installed. If you are faced with such a problem you can use any of the following techniques to find MySQL version number.

  1. Mysql Workbench Select Schema
  2. Mysql Workbench Select Database
  3. Mysql Workbench Select All Rows
  4. Mysql Workbench Select Statements

I am going to show you how to find MySQL version number using the following tools and techniques:

Please note that these techniques will work on most/all platforms (including Windows, Solaris, Linux etc) where MySQL and clients can be installed. This also includes major Linux distributions like Ubuntu, Centos, Debian, Gentoo etc

To set a default schema for multiple MySQL Workbench sessions, you must set the default schema for the stored connection. From the home screen, right-click on a MySQL connection, choose Edit Connection, and set the desired default schema on the Default Schema box. MySQL provides some features for particular version numbers and on particular platforms only. So, in some situations it gets really important to find the MySQL version number installed. If you are faced with such a problem you can use any of the following techniques to find MySQL version number.

Mysql Workbench Select Schema

Using MySQL client (e.g CLI, Query Browser) to check MySQL version:

If you are using a MySQL client e.g. MySQL command line or Query Browser, you can simply execute the following mysql version query.

Mysql

SELECT version();

OR

SELECT @@version;

Output:

You can also use the STATUS command in MySQL cli tool to find MySQL version number (output truncated)

Using MySQL Workbench:

You could also use MySQL Workbench to check the version number for MySQL. Once you are connected to a server using MySQL Workbench, click on Server from main menu and then 'Server Status' to view the server status (including version).

Using MySQL Administrator (free GUI tool) to check MySQL version:

OR if you have access to MySQL Administrator and you are connected to the server. Just click on 'Server Information' on the left side pane. The version information will be displayed on the right side pane.

Mysql Workbench Select Database

Using mysqladmin to check MySQL version:

You can also find the version number using mysqladmin command line tool. mysqladmin will also provide you good information about the server e.g. uptime, open tables etc.. Here is how I ran it on my windows machine.

Mysql Workbench Select All Rows

Using phpMyAdmin:

Mysql Workbench Select Statements

Click on home icon on the top-left corner of any page or click on 'Server:<hostname>' link at the very top. You should see MySQL server's version number on the right side of the page (something like the image below).

Did this tutorial help a little? How about buy me a cup of coffee?

Please feel free to use the comments form below if you have any questions or need more explanation on anything. I recommend thoroughy testing on aproduction-like test system first before moving to production.