Installing MySQL And MySQL Workbench on Mac OS

It is little bit of tricky to install especially mysql on Mac, but workbench is very simple to install but lets walk towards our preparation and installation, the below download the apps, you will need to download MySQL 64 bit architecture for 10.7 dmg file but it is still fine if you are on ML or Maverics

MySQL 5.6

MySQL Workbench

Once we download and lauch mysql installation, we will have 3 packages, keep installing them and continue the process below

issue this command:

cd ; vi .bash_profile

and add this line

export PATH="/usr/local/mysql/bin:$PATH"

and issue this command one more time

source ~/.bash_profile

and lets see our mysql version

mysql -v

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.6.15 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, 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.

set the root password:

/usr/local/mysql/bin/mysqladmin -u root password 'yourpasswordhere'

and we are all good with the installation of Mysql, you may now install workbench and test our database

Leave a Reply

Your email address will not be published. Required fields are marked *