Installing MySQL, mysqlworkbench and mysql-utils in Yosemite
$ brew install mysql $ mysql.server start # and optionaly make it more secure $ mysql_secure_installation
$ brew tap caskroom/cask # optional $ brew install homebrew/completions/brew-cask-completion ## install workbench and utils $ brew cask install mysqlworkbench # mysqlworkbench staged at '/opt/homebrew-cask/Caskroom/mysqlworkbench/6.3.6' # Symlinking App 'MySQLWorkbench.app' to '/Users/pmg/Applications/MySQLWorkbench.app' $ brew cask install mysql-utilities # mysql-utilities staged at '/opt/homebrew-cask/Caskroom/mysql-utilities/1.5.6'
Note that workbench is symlinked to your home apps not the main Application folder
Launch it and you will get this window with the MySQL Utils icon at the top right
MySQL Utils launch a console and the error message is
$ mysqluc -e "help utilities" ERROR: The MySQL Connector/Python module was not found. MySQL Utilities requires the connector to be installed. Please check your paths or download and install the Connector/Python from http://dev.mysql.com.
at http://dev.mysql.com/downloads/connector/python/ but instead of selecting Mac choose "platform independent"
choose download and and then copy the link from "no thanks, just start download"
Go back to your shell and download it (you can do it in the mysql-utils dir just to have all together)
$ cd /opt/homebrew-cask/Caskroom/mysql-utilities/ $ wget http://dev.mysql.com/get/Downloads/Connector-Python/mysql-connector-python-2.1.3.tar.gz $ tar -zxvf mysql-connector-python-2.1.3.tar.gz $ cd mysql-connector-python-2.1.3/ # install for both python $ sudo python ./setup.py install $ sudo python3 ./setup.py install </ pre>
Now when you click in the MySQL-Utils you have a working connection and you see this in the launched terminal
I have tried to install the connector from python using pip but it did not work due a problem with ConfigParser. I did not investigate it further because I have already a working solution.