{"id":3295,"date":"2017-05-11T10:41:08","date_gmt":"2017-05-11T10:41:08","guid":{"rendered":"http:\/\/www.nikola-breznjak.com\/blog\/?p=3295"},"modified":"2017-05-11T10:46:07","modified_gmt":"2017-05-11T10:46:07","slug":"stop-remove-mysql-server-mac-keep-client","status":"publish","type":"post","link":"https:\/\/nikola-breznjak.com\/blog\/quick-tips\/stop-remove-mysql-server-mac-keep-client\/","title":{"rendered":"How to stop and remove MySQL server on a Mac but keep the client"},"content":{"rendered":"

Remove MySQL server on a Mac<\/h2>\n

The other day I wanted to run some project via Docker Compose. Surprisingly, the MySQL service defined normally like this:<\/p>\n

mysql:\n       image: tutum\/mysql\n       env_file:\n         - docker.env\n       ports:\n         - \"3306:3306\"\n<\/code><\/pre>\n
didn’t start, because I apparently had MySQL server already running locally.<\/p>\n
Trust me, I tried everything from this StackOverflow post<\/a> but any time I tried to kill the process (that I saw is running with ps aux | grep mysql<\/code>) it would spun back up.<\/p>\n
Then, I remembered that I installed MySQL server some time ago via the app called MAMP. I went in and removed all of that and also I found one post<\/a> that I’ll paste here (full credit to Vitor Britto<\/a>):<\/p>\n
# Remove MySQL completely\n\n1. Open the Terminal\n2. Use `mysqldump` to backup your databases\n3. Check for MySQL processes with: `ps -ax | grep mysql`\n4. Stop and kill any MySQL processes\n5. Analyze MySQL on HomeBrew: \n\n    ```\n    brew remove mysql\n    brew cleanup\n    ```\n\n6. Remove files: \n\n    ```\n    sudo rm \/usr\/local\/mysql\n    sudo rm -rf \/usr\/local\/var\/mysql\n    sudo rm -rf \/usr\/local\/mysql*\n    sudo rm ~\/Library\/LaunchAgents\/homebrew.mxcl.mysql.plist\n    sudo rm -rf \/Library\/StartupItems\/MySQLCOM\n    sudo rm -rf \/Library\/PreferencePanes\/My*\n    ```\n\n7. Unload previous MySQL Auto-Login: \n\n    ```\n    launchctl unload -w ~\/Library\/LaunchAgents\/homebrew.mxcl.mysql.plist\n    ```\n\n8. Remove previous MySQL Configuration: \n\n    ```\n    subl \/etc\/hostconfig` \n    # Remove the line MYSQLCOM=-YES-\n    ```\n\n9. Remove previous MySQL Preferences: \n\n    ```\n    rm -rf ~\/Library\/PreferencePanes\/My*\n    sudo rm -rf \/Library\/Receipts\/mysql*\n    sudo rm -rf \/Library\/Receipts\/MySQL*\n    sudo rm -rf \/private\/var\/db\/receipts\/*mysql*\n    ```\n\n10. Restart your computer just to ensure any MySQL processes are killed\n11. Try to run mysql, **it shouldn't work**\n<\/code><\/pre>\n
Keep the MySQL client for interacting with the MySQL databases<\/h2>\n
At this point, I removed everything related to MySQL, but I still needed the client to connect to the MySQL database that I ran with Docker Compose.<\/p>\n
The fastest way (that I’ve found in this StackOverflow post<\/a>) to install the client without installing the server was to install MySQLWorkbench<\/a> and then add this to your path (I put these in my .zshrc<\/code> file; you may use .bashrc<\/code>):<\/p>\n
export PATH=$PATH:\/Applications\/MySQLWorkbench.app\/Contents\/MacOS\n<\/code><\/pre>\n
Of course, the path may vary for you in case you’ve installed it in some other location. Anyway, hope this helps someone… ?<\/em><\/p>\n
\n
How to stop and remove #MySQL<\/a> server on a Mac but keep the client https:\/\/t.co\/0vtuBgOqMD<\/a><\/p>\n
— Nikola Bre\u017enjak (@HitmanHR) May 11, 2017<\/a><\/p><\/blockquote>\n