Active4 months ago
MySQL Workbench is a visual tool for database architects and developer. It offers administration tools for server configuration, user administration and much more. It is available on Windows, Linux, and MAC. Welcome to Reddit's community for users, developers, and hackers of Mac OS X – the computer operating system from Apple! Please share your tips, tricks, hacks, creations, and humor related to the best desktop environment out there.
Software clients are constantly released and updated according to what's common on the market. The best place to learn these things would be in the Stack Exchange Third Place (our chat system) and to ask people what they are currently using. Client for MySQL by EngInSite. This all-in-one tool will help you create, manage and edit MySQL databases. One intuitive interface for all tasks. SQL Visualizer is a Windows client SQL Server database query and management tool that allows you to easily navigate around your database objects and allows you to visualize what is happening within both the database and SQL code.
I want to install the MySQL client for the command line, not a GUI. I have searched over the web but only found instructions on installing the MySQL server.
Michael Lihs2,82766 gold badges2727 silver badges5454 bronze badges
hchhch1,45455 gold badges1414 silver badges2121 bronze badges
13 Answers
user1659189user16591891,50911 gold badge99 silver badges44 bronze badges
If you have already installed MySQL from the disk image (dmg) from http://dev.mysql.com/downloads/), open a terminal, run:
then, reload
.bash_profile
by running following command:You can now use
mysql
to connect to any mysql server:Credit & Reference: http://www.gigoblog.com/2011/03/13/add-mysql-to-terminal-shell-in-mac-os-x/
Michael Lihs2,82766 gold badges2727 silver badges5454 bronze badges
JackSparrowJackSparrow
Michael Lihs2,82766 gold badges2727 silver badges5454 bronze badges
GeekGeek
Mysql has a client-only set of utilities:
Mysql client shellhttps://dev.mysql.com/downloads/shell/
Other command line utilitieshttps://dev.mysql.com/downloads/utilities/
Mac OSX version available.
trosemantroseman
There is now a
mysql-client
formula.brew install mysql-client
egzeegze
Open the 'MySQL Workbench' DMG file and
Eject the DMG disk
caccialdocaccialdo
There is a Homebrew formulae for just a client: https://formulae.brew.sh/formula/mysql-client
Install it by:
IvanIvanbrew install mysql-client
4,28944 gold badges3737 silver badges5555 bronze badges
For installing
mysql-shell
with homebrew, runyou can then launch the mysql shell with
if you want to enter SQL mode directly, run
Michael LihsMichael Lihs2,82766 gold badges2727 silver badges5454 bronze badges
This strictly installs a command line client, without the other overhead:
Install Homebrew (if you don't have it):
Then, install
mysql-client
:Then, add the
mysql-client
binary directory to your PATH:Finally, reload your bash profile:
Then you should be able to run
Alex WAlex Wmysql
in a terminal, if not try opening a new terminal29k77 gold badges7272 silver badges8686 bronze badges
Torrent Client For Mac
If you installed from the DMG on a mac, it created a mysql client but did not put it in your user path.
Add this to your
.bash_profile
:This will let you run
Michael Lihsmysql
from anywhere as you.2,82766 gold badges2727 silver badges5454 bronze badges
Paul KenjoraPaul Kenjora
As stated by the earlier answer you can get both mysql server and client libs by running
brew install mysql
.There is also client only installation. To install only client libraries run
brew install mysql-connector-c
In order to run these commands, you need homebrew package manager in your mac. You can install it by running
/usr/bin/ruby -e '$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)'
2,11133 gold badges2222 silver badges3939 bronze badges
The easiest way would be to install mysql server or workbench, copy the mysql client somewhere, update your path settings and then delete whatever you installed to get the executable in the first place.
WillaWilla
Using MacPorts you can install the client with:
You also need to select the installed version as your mysql
The server is only installed if you append
-server
to the package name (e.g. mysql57-server
)Alex GAlex G
protected by Bhargav Rao♦May 24 '17 at 7:51
Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Would you like to answer one of these unanswered questions instead?
Not the answer you're looking for? Browse other questions tagged mysqlmacosterminal or ask your own question.
Version 18.1.0.0.0 (64-bit)
Base - one of these packages is required
Name | Download | Description |
---|---|---|
Basic Package | All files required to run OCI, OCCI, and JDBC-OCI applications (71,982,447 bytes) (cksum - 1702106497) | |
Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (35,297,778 bytes) (cksum - 2930628103) |
Tools - optional packages
Name | Download | Description |
---|---|---|
SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (916,567 bytes) (cksum - 1531146804) | |
Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (1,205,728 bytes) (cksum - 3871420477) |
Development and Runtime - optional packages
Mac Database Client
Name | Download | Description |
---|---|---|
SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (Updated 5 March 2019) (925,639 bytes) (cksum - 1251767455) | |
JDBC Supplement Package | Additional support for Internationalization under JDBC (1,572,899 bytes) (cksum - 3513377311) | |
ODBC Package | Additional libraries for enabling ODBC applications (1,998,707 bytes) (cksum - 3748565934) | |
Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 12.2.0.1.0 (64-bit) Updated 15-Jan-2018
Base - one of these packages is required
Name | Download | Description |
---|---|---|
Basic Package | All files required to run OCI, OCCI, and JDBC-OCI applications (68,160,048 bytes) (cksum - 2145539248) | |
Basic Light Package | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (32,101,235 bytes) (cksum - 1597579561) |
Tools - optional packages
Name | Download | Description |
---|---|---|
SQL*Plus Package | The SQL*Plus command line tool for SQL and PL/SQL queries (905,985 bytes) (cksum - 3193372887) | |
Tools Package | Includes Data Pump, SQL*Loader and Workload Replay Client (1,188,607 bytes) (cksum - 4234197225) |
Mysql Client Mac Os
Development and Runtime - optional packages
Best Sql Client For Mac
Name | Download | Description |
---|---|---|
SDK Package | Additional header files and an example makefile for developing Oracle applications with Instant Client (673,883 bytes) (cksum - 3731483473) | |
JDBC Supplement Package | Additional support for Internationalization under JDBC (1,570,334 bytes) (cksum - 1705103068) | |
ODBC Package | Additional libraries for enabling ODBC applications (1,962,870 bytes) (cksum - 3397148646) | |
Precompiler Package | Precompiler Downloads | Additional files for Pro*C and Pro*COBOL |
Version 12.1.0.2 (64-bit) Updated 5-Jul-2017
Free Sql For Mac
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (63,591,161 bytes) (cksum - 2819753276) | |
Instant Client Package - Basic Light | Smaller version of the Basic package, with only English error messages and Unicode, ASCII, and Western European character set support (31,539,594 bytes) (cksum - 1112518720) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (143,238 bytes) (cksum - 988652685) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (871,943 bytes) (cksum - 1242636584) | |
Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (1,865,942 bytes) (cksum - 2249115520) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (664,114 bytes) (cksum - 670890418) | |
Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (236,151 bytes) (cksum - 3773150080) | |
Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 12.1.0.2 (32-bit) Updated 4-Jan-17
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (64,143,856 bytes) (cksum - 3075410801) | |
Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (32,093,291 bytes) (cksum - 1437280362) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (143,295 bytes) (cksum - 2965858677) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (892,440 bytes) (cksum - 1535728498) | |
Instant Client Package - ODBC | Additional libraries for enabling ODBC applications (1,883,055 bytes) (cksum - 1502599121) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (664,121 bytes) (cksum - 2233654893) | |
Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (258,686 bytes) (cksum - 2882512306) | |
Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 11.2.0.4.0 (64-bit)
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (62,794,903 bytes) | |
Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (26,034,836 bytes) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,560,298 bytes) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (884,608 bytes) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (651,903 bytes) | |
Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (235,951 bytes) | |
Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 11.2.0.4.0 (32-bit)
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (58,425,231 bytes) | |
Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (23,003,182 bytes) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (11,078 bytes) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (800,263 bytes) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (651,903 bytes) | |
Instant Client Package - WRC | Workload Replay Client used to replay workload for RAT's DB Replay Feature (197,708 bytes) | |
Precompiler Package | Precompiler Downloads | Additional files for 'proc' binary and related files to precompile a Pro*C application and demo |
Version 10.2.0.4 (64-bit)
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (35,013,419 bytes) | |
Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only) (11,877,594 bytes) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,493,189 bytes) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (746,094 bytes) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (603,530 bytes) |
Version 10.2.0.4 (32-bit)
Name | Download | Description |
---|---|---|
Instant Client Package - Basic | All files required to run OCI, OCCI, and JDBC-OCI applications (34,109,360 bytes) | |
Instant Client Package - Basic Light | Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only) (10,975,530 bytes) | |
Instant Client Package - JDBC Supplement | Additional support for XA, Internationalization, and RowSet operations under JDBC (1,490,104 bytes) | |
Instant Client Package - SQL*Plus | Additional libraries and executable for running SQL*Plus with Instant Client (711,801 bytes) | |
Instant Client Package - SDK | Additional header files and an example makefile for developing Oracle applications with Instant Client (603,526 bytes) |