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!
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
If you tried to remove mysql beforehand after some install, you might have broken mysql installation, to fully remove it run this:
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.
brew install mysql
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
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.
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.
vitali.pom dot com