Check mySQL version on Mac 10.8.5

How can I check (step-by-step ) the version of mySQL installed on my Mac 10.8.5?

I tried using command prompt, but couldn't figure out.

Every time you used the mysql console, the version is shown.

 $ mysql -u user

Successful console login shows the following which includes the mysql server version.

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1432
Server version: 5.5.9-log Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

You can also check the mysql server version directly by executing the following command:

$ mysql --version

You may also check the version information from the mysql console itself using the version variables:

mysql> SHOW VARIABLES LIKE "%version%";

Output will be something like this:

+-------------------------+---------------------+
| Variable_name           | Value               |
+-------------------------+---------------------+
| innodb_version          | 1.1.5               |
| protocol_version        | 10                  |
| slave_type_conversions  |                     |
| version                 | 5.5.9-log           |
| version_comment         | Source distribution |
| version_compile_machine | i386                |
| version_compile_os      | osx10.4             |
+-------------------------+---------------------+
7 rows in set (0.01 sec)

You may also use this:

mysql> select @@version;

The STATUS command display version information as well.

mysql> STATUS

You can also check the version by executing this command:

mysql -v

If you have encountered something like this:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

You can fix it by:

sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock /tmp/mysql.sock

How To Check If MySQL Is Installed And Running , What version of MySQL do I have Windows command line? [/quote] Are you sure about this? Did you check it? It provides the download for 1.6 and 1.7 only. No 1.8. Now if you can send me the dmg file for 1.8 I would be able to test it. It just you will need to send me the uninstall script as well. So that the version I have right now can be uninstalled. Can you do that? [quote] Thank you for the feedback.

To check your MySQL version on your mac, navigate to the directory where you installed it (default is usr/local/mysql/bin) and issue:

./mysql --version

Alternatively, to avoid needing to navigate to that specific dir to run the command, add its location to your path. There's more than one way to add a dir to your $PATH (with explanations on stackoverflow and other places on how to do so), such as adding it to your ./bash_profile.

After adding the mysql bin dir to your $PATH, verify it's there by executing:

echo $PATH

Thereafter you can check your mysql version from anywhere by running (note no "./"):

mysql --version

Find out where MySQL is installed on Mac OS X, To check MySQL version of MAMP , use the following command in Terminal: /​Applications/MAMP/Library/bin/mysql --version. Assume you have  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. Using mysqladmin to check MySQL version:

Or just call mysql command with --version option.

mysql --version

MySQL and OS X :: 1 Installing MySQL on macOS, MySQL and OS X / Installing MySQL on macOS. Chapter 1 Installing MySQL on macOS. For a list of macOS versions that the MySQL server supports, see  To check your MySQL version on your mac, navigate to the directory where you installed it (default is usr/local/mysql/bin) and issue: ./mysql --version Alternatively, to avoid needing to navigate to that specific dir to run the command, add its location to your path.

You should be able to open terminal and just type

mysql -v

Check MySQL Version on Mac OSX, To Check MySQL Version on Mac OSX simply open up Terminal and type / copy and paste:- The MySQL version is outputted after 'Server version: x.x.x MySQL'  MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts. MySQL Cluster Community Edition is available as a separate download. The reason for this change is so that MySQL Cluster can provide more frequent updates

How to Install and Configure MySQL in OS X 10.8 Mountain Lion , MySQL is a free and open source relational database. You'll then see several downloads for OS X, some for older versions of the operating  In the previous versions of MySQL, before every upgrade our consultants manually spend several hours testing compatibility but MySQL 8 made this simple by introducing “upgrade checker” javascript with MySQL Shell 8.0.11 , In this blog we are writing about “upgrade checker” utility and upgrade from MySQL 5.7 to MySQL 8.0 .

Upgrade MySQL Database from 5.5 to 5.6 on OSX 10.8 Mountan Lion, how to upgrade MySQL from a previous version such as 5.5 to 5.6 on OSX, migrate databases and repair any tables. MySQL version 5.6.14 is available for download for OSX, a double click and install is Check the Version. If your Mac is using an earlier version of any Mac operating system, you should install the latest Apple software updates, which can include important security updates and updates for the apps installed by macOS, such as Safari, Books, Messages, Mail, Music, Calendar, and Photos. macOS High Sierra. OS X El Capitan. OS X Mountain Lion.

How To Check MySQL Version: 5 Easy Commands {Ubuntu, Linux}, This command works on Windows, OS X, and Linux distributions including Ubuntu. MySQL client version 10.4.5-MariaDB. The MySQL client  # mysql -V I tried to search checking mysql version on the command line a couple times without success, so it’s going down here. The smart person would of course just read the mysql man page.

Comments
  • question tagged as osx-snow-leopard? Mac 10.8.x = Mountain Lion. hehe. just saying.