I always use Homebrew when I install any software tools.
I will start to download MySQL by using brew install mysql
After that I need to set environment of the MySQL so I'm opening vim editor with this command:
vim .bash_profile and then I need to add these lines:
export MYSQL_HOME=/usr/local/mysql-5.6.19-osx10.7-x86_64
export MYSQL=$MYSQL_HOME/bin
export PATH=$MYSQL:$PATH
At this step you need to download and install MySQL 6.1.7 in order to start and stop MySQL server by using this path:http://dev.mysql.com/downloads/file.php?id=452671
By the way,you need to have an account in order to access download link there.
After you click Next and install successfully you should to see MySQL under Apple Logo ->System Preferences ->MySQL Image at the end of the page
Here is image of the MySQL:
Here is image of the MySQL:
Now I'm able to use mysql command in my terminal when I write it, I should to see this lines:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.6.19 MySQL Community Server (GPL)
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
We can connect to MySQL Workbench after I open MySQL port and I perform any query on this platform.
