Remove MySQL completely from Mac OSX

rm_mysql.md

Remove MySQL completely

1. Open the Terminal

2. Use mysqldump to backup your databases

3. Check for MySQL processes with: ps -ax | grep mysql

4. Stop and kill any MySQL processes

5. Analyze MySQL on HomeBrew:

   brew remove mysql
   brew cleanup
   

6. Remove files:

   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*
   

7. Unload previous MySQL Auto-Login:

   launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
   

8. Remove previous MySQL Configuration:

   # Edit this file: /etc/hostconfig
   # Remove the line MYSQLCOM=-YES-
   

9. Remove previous MySQL Preferences:

   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*
   

10. Restart your computer just to ensure any MySQL processes are killed

11. Try to run mysql, it shouldn't work

rm_mysql_apple_silicon.md

Remove MySQL completely (Apple Silicon Version)

• brew remove mysql
• rm -rf /opt/homebrew/var/mysql
• brew install mysql
• mysql.server start
• mysql -uroot

Thanks

how do we do step 8... removing the line part

Thanks a lot. It would have been good if I got this article first. I would have saved about 5 hours :-(

Thank you so much. I wish I had landed up on this page much earlier. I struggled so much. This is an excellent page, Thanks 👍

Thank you! Very helpful!

Thank you very much. It is notoriously difficult to uninstall mysql data. Your tutorial did the trick! 👍

subl /etc/hostconfig`
has a hanging backtick

👍

thank you very much

Thank you , it's help a lot !

Aaah, Thanks man!

Thank you

Nice work! Thank you

subl /etc/hostconfig`
has a hanging backtick

Also, not everyone has sublime text. Better to simply say "edit this file".

This is very helpful! Thank you!

On the Apple Silicon:

brew remove mysql
rm -rf /opt/homebrew/var/mysql
brew install mysql
mysql.server start
mysql -uroot

subl /etc/hostconfig`
has a hanging backtick

Also, not everyone has sublime text. Better to simply say "edit this file".

Thanks @commadelimited, gist updated.

subl /etc/hostconfig`
has a hanging backtick

Thanks @lexjacobs, gist updated.

When setting up my Apple M1 Macbook Pro I was experiencing the issue of the following error message being thrown:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

My fix was to modify the MySQL config file:

nano /usr/local/etc/my.cnf

Append the following lines:

tmpdir=/tmp
user=root

Then run:

brew services restart mysql@5.7

This fixed my issue, and I was then able to connect successfully with my DB client.

@seemly Thanks for this

Thanks <3

This was very helpful. I also had to do:

rm /usr/local/etc/my.cnf

Something I had done previously had resulted in a my.cnf file that prevented MySQL from working (I was getting the dreaded ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) error).

Thank you! This was what I needed!

Awesome Thanks 😊🙌🏻

saved my day! Thank you :)

Thank god for your beautiful ass mate, I was looking for this for like an hour

Append the following lines to:

• /opt/homebrew/etc/my.cnf

• /opt/homebrew/Cellar/mysql@5.7/5.7.37/.bottle/etc/my.cnf

tmpdir=/tmp
user=root

Thanks @seemly it's worked , i spend 8 hours searching .

@seemly you saved me with these Comment : here

Thanks for this awesome guide.
@tnorthcutt's reply helped a lot!

Thanks, it worked!!

Thanks

nice