loading...

OS X MySQL Install Complete Tutorial

vitalipom profile image Vitali Pomanitski ・3 min read

MySQL OS X: Install Using Homebrew Quick Setup

Sometimes you just want to perform some additional common operations that are not available through quick pipes and bash commands and you don't want to hustle with Excel or any unusable script. So you just prefer to install MySQL and use queries to perform additional operation and output some .csv file, but usually you don't go through it on your regular job or daily work basis just because you don't want to run though all the processes. This is a quick tutorial for mysql os x installation, completely working, using the 2018 software.

We assume you already have Homebrew!

Part 1 - killall

If you have an older system or chances you have had older or any other unstable mysql, you can stop/kill the processes somehow like this:

sudo killall mysqld
sudo killall mysql

Part 2 - clear old mysql

If you tried to remove mysql beforehand after some install, you might have broken mysql installation, to fully remove it run this:

credit: https://coderwall.com/p/os6woq/uninstall-all-those-broken-versions-of-mysql-and-re-install-it-with-brew-on-mac-mavericks

brew remove mysql
brew cleanup
sudo rm /usr/local/mysql 
sudo rm -rf /usr/local/var/mysql 
sudo rm -rf /usr/local/mysql* 
sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist 
sudo rm -rf /Library/StartupItems/MySQLCOM 
sudo rm -rf /Library/PreferencePanes/My* 
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist 
edit /etc/hostconfig and remove the line MYSQLCOM=-YES- 
rm -rf ~/Library/PreferencePanes/My* 
sudo rm -rf /Library/Receipts/mysql* 
sudo rm -rf /Library/Receipts/MySQL* 
sudo rm -rf /private/var/db/receipts/*mysql*  

Now no MySQL at all on your computer at least except for PATH variables and alias.

Part 3 - quick install

brew install mysql

Part 4 - quick setup

This is the place where mac users fall to install mysql and the tutorials point to unusual and non working setup commands.

[tag: quick setup for mysql server on os x using homebrew installation, the really working tutorial 2018 for mac and os x users]

The first line is must. We turn on mysql that we installed from brew, using brew. Once we run it the suggested setup will workout as well (which it didn't).

brew services start mysql
mysql_secure_installation

Part 4 - quick run

mysql is already running using the `brew services start mysql` command

Setup fish shell which allows full support to autocomplete suggestions and Iterm2 which supports completely fish autocomplete and allows complete navigation with the fish shell using the Magic keyboard from Apple.


Guys
Dear friends and fellows,
If you like my tutorial please download Effectedkeyboard for Android from here I promise you to be it the most comfortable and animated keyboard for Android one day. Today I use it on OnePlus 5 and I see it working completely well on some other devices. It has no bugs as of today and it has clearly some beneficial futures that you might like. Please download it and rate it on the Google app store.
Thanks ahead,
Pomanitski Vitali
vitali.pom dot com


Posted on by:

vitalipom profile

Vitali Pomanitski

@vitalipom

Entrepreneur • Developer • Open Source Contributor • Verification Intern • EE Student • CS Bachelor

Discussion

markdown guide