Best Sql Client For Mac -mysql

Best Video Software for the Mac How To Run MacOS High Sierra or Another OS on Your Mac Best. Free My SQL Community Mac OS. Connect, browse, update & manage databases from one database client. 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 OS X. Squirrel SQL is an excellent DB Client for any database, and it's free. It is as good (I would say even better)as any for-sale tool. I've been using it for years and it keeps getting better.

Active4 months ago

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 Lihs
2,8276 gold badges27 silver badges54 bronze badges
hchhch
1,4545 gold badges14 silver badges21 bronze badges

13 Answers

user1659189user1659189
1,5091 gold badge9 silver badges4 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 Lihs
2,8276 gold badges27 silver badges54 bronze badges
JackSparrowJackSparrow
Michael Lihs
2,8276 gold badges27 silver badges54 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/

Best sql client for mac

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: brew install mysql-client

IvanIvan
4,2894 gold badges37 silver badges55 bronze badges

For installing mysql-shell with homebrew, run

you can then launch the mysql shell with

if you want to enter SQL mode directly, run

Michael LihsBest Sql Client For Mac -mysqlMichael Lihs
2,8276 gold badges27 silver badges54 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 mysql in a terminal, if not try opening a new terminal

Alex WAlex W
29k7 gold badges72 silver badges86 bronze badges

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 mysql from anywhere as you.

Michael Lihs
2,8276 gold badges27 silver badges54 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)'

Kimmo HintikkaKimmo Hintikka
2,1113 gold badges22 silver badges39 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:

Mac Os Sql Client

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 RaoMay 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?

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

Torrent Client For Mac

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

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 PackagePrecompiler 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)

Development and Runtime - optional packages

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 PackagePrecompiler Downloads Additional files for Pro*C and Pro*COBOL

Version 12.1.0.2 (64-bit) Updated 5-Jul-2017

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 PackagePrecompiler 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

Free Sql For Mac

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 PackagePrecompiler Downloads Additional files for 'proc' binary and related files to precompile a Pro*C application and demo

Best Sql Client For Mac

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 PackagePrecompiler 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)

Mac Database Client

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 PackagePrecompiler 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)