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.
Valentina Studio supports MySQL and its available on the Mac and it is free. It also supports all major databases in addition to MySQL. You can do these things with the free version: Create/Drop/Alter/Browse Tables, Fields, Indexes, Triggers, Constraints, Links, Views. ./mysql Ver 14.14 Distrib 5.1.44, for apple-darwin8.11.1 (i386) using EditLine wrapper UPDATE: Moreover, if you want to find where does mysql installed in system, use the following command: type -a mysql type -a is an equivalent of tclsh built-in command where in OS X bash shell. If MySQL is found, it will show: mysql is /usr/bin/mysql.
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:
Mysql Client Download Mac Download
Credit & Reference: http://www.gigoblog.com/2011/03/13/add-mysql-to-terminal-shell-in-mac-os-x/
Mysql has a client-only set of utilities:
Mysql client shell
Other command line utilities
Mac OSX version available.
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.
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:
Mysql Client Download
Download Mysql Client For Mac
This will let you run “mysql” from anywhere as you.
Open the “MySQL Workbench” DMG file and
Eject the DMG disk
Tried mysql utilities but didn’t work for one MacOS. Finally went with Sequel Pro http://sequelpro.com/. This does not exactly address the ‘no gui’ requirement of the question but that’s what I also started out with.
Tags: mysql, sql