Clean uninstall and install MySql on MacOS

Clean uninstall and install MySql on MacOS.md

Clean uninstall MySql from MacOS

1. ps -ax | grep mysql
2. stop and kill any MySQL processes
3. brew remove mysql
4. brew cleanup
5. sudo rm /usr/local/mysql
6. sudo rm -rf /usr/local/var/mysql
7. sudo rm -rf /usr/local/mysql*
8. sudo rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
9. sudo rm -rf /Library/StartupItems/MySQLCOM
10. sudo rm -rf /Library/PreferencePanes/My*
11. launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
12. edit /etc/hostconfig and remove the line MYSQLCOM=-YES-
13. rm -rf ~/Library/PreferencePanes/My*
14. sudo rm -rf /Library/Receipts/mysql* 14.sudo rm -rf /Library/Receipts/MySQL* 15.sudo rm -rf /private/var/db/receipts/mysql
15. restart your computer just to ensure any MySQL processes are killed try to run mysql, it shouldn't work

Install MySql on macOS

1. brew doctor and fix any errors
2. brew update
3. brew install mysql
4. unset TMPDIR
5. mysql_install_db --verbose --user=whoami --basedir="$(brew --prefix mysql)" --datadir=/usr/local/var/mysql --tmpdir=/tmp
6. brew services start mysql
7. mysql_secure_installation

Run other commands Brew suggests if needed