Installing MySQL, mysqlworkbench and mysql-utils in Yosemite
For installing things like *nix in MacOSX I use homebrew.
Homebrew is fantastic for installing tar.gz files in textual way, but there are some packages that are only in .dmg format and you need to use a package manager that knows how to install this GUI based installers. This package manager is homebrew cask (caskroom project)
First you need to install mysql
$ brew install mysql $ mysql.server start # and optionaly make it more secure $ mysql_secure_installation
Then you need to 'tap' the cask project and then get your 'cask' before 'pouring' it.
Note that workbench is symlinked to your home apps not the main Application folder
$ 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
~/Applications/MySQLWorkbench.app
Launch it and you will get this window with the MySQL Utils icon at the top right
When you click in the MySQL Utilities.... OPS!! it does not work!
MySQL Utils launch a console and the error message is
OK, let's find the connector googleing it. And find it
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)
Now when you click in the MySQL-Utils you have a working connection and you see this in the launched terminal
P.S.
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.
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.
[EDIT] I have just missed that the mysql-connector-python is also in cask and you can install with `brew cask install mysql-connector-python` BUT IT DID NOT WORK FOR ME
$ brew search mysql
automysqlbackup mysql ✔ mysql++ mysql-cluster mysql-connector-c mysql-connector-c++ mysql-sandbox mysql-search-replace mysqltuner
homebrew/php/php53-mysqlnd_ms homebrew/php/php55-mysqlnd_ms homebrew/versions/mysql51 homebrew/versions/mysql56 Caskroom/cask/mysql-utilities Caskroom/cask/navicat-for-mysql
homebrew/php/php54-mysqlnd_ms homebrew/php/php56-mysqlnd_ms homebrew/versions/mysql55 Caskroom/cask/mysql-connector-python Caskroom/cask/mysqlworkbench
$ brew cask install mysql-connector-python
Error: No available Cask for mysql-connector-python
Error: nothing to install
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
P.S.
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.
MacBook-Pro:[~]
$ pip3 install MySQL-python
Collecting MySQL-python
Downloading MySQL-python-1.2.5.zip (108kB)
Complete output from command python setup.py egg_info:
Traceback (most recent call last):
File "<string>", line 20, in <module>
File "/private/var/folders/m0/spbgfzvd17jdfqgx90w1_hx40000gn/T/pip-build-0nif_qmi/MySQL-python/setup.py", line 13, in <module>
from setup_posix import get_config
File "/private/var/folders/m0/spbgfzvd17jdfqgx90w1_hx40000gn/T/pip-build-0nif_qmi/MySQL-python/setup_posix.py", line 2, in <module>
from ConfigParser import SafeConfigParser
ImportError: No module named 'ConfigParser'
----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /private/var/folders/m0/spbgfzvd17jdfqgx90w1_hx40000gn/T/pip-build-0nif_qmi/MySQL-python
You are using pip version 7.1.2, however version 8.0.2 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
MacBook-Pro:[~]
$ pip3 install ConfigParser
Collecting ConfigParser
Downloading configparser-3.3.0r2.tar.gz
Complete output from command python setup.py egg_info:
Traceback (most recent call last):
File "<string>", line 3, in <module>
File "/usr/local/lib/python3.5/site-packages/setuptools/__init__.py", line 5, in <module>
import distutils.core
File "/usr/local/Cellar/python3/3.5.0/Frameworks/Python.framework/Versions/3.5/lib/python3.5/distutils/core.py", line 18, in <module>
from distutils.config import PyPIRCCommand
File "/usr/local/Cellar/python3/3.5.0/Frameworks/Python.framework/Versions/3.5/lib/python3.5/distutils/config.py", line 7, in <module>
from configparser import ConfigParser
File "/private/var/folders/m0/spbgfzvd17jdfqgx90w1_hx40000gn/T/pip-build-0ouo8j8z/ConfigParser/configparser.py", line 397
_KEYCRE = re.compile(ur"%\(([^)]+)\)s")
^
SyntaxError: invalid syntax
----------------------------------------
Posts
