How to reinstall MySQL on Mac

Reinstalling MySQL on a Mac can be a relatively straightforward process. This guide is tailored for engineers who want to get the job done without the fluff.

Step 1: Backup Your Data

Before any significant software change, it's a good practice to backup your data.

mysqldump -u [username] -p --all-databases > backup.sql

Replace [username] with your MySQL username.

Step 2: Uninstall MySQL

a. Stop the MySQL Service

If MySQL is running, you'll want to stop it:

sudo mysql.server stop

b. Remove MySQL Packages

Remove the MySQL software:

sudo rm /usr/local/mysql
sudo rm -rf /usr/local/var/mysql
sudo rm -rf /usr/local/mysql*

c. Remove MySQL Preference Pane

If you've installed the MySQL Preference Pane, you should also remove it:

sudo rm -rf /Library/PreferencePanes/My*

d. Clean Up

Clean up any lingering items:

sudo rm -rf /Library/StartupItems/MySQLCOM
sudo rm -rf /Library/Receipts/mysql*
sudo rm -rf /Library/Receipts/MySQL*
sudo rm -rf /private/var/db/receipts/*mysql*

Step 3: Reinstall MySQL

a. Download MySQL

Visit the official MySQL website and download the version for macOS: MySQL Downloads

b. Install MySQL

Open the downloaded .dmg file and follow the installation instructions. Generally, it's a matter of dragging and dropping the MySQL icon into your Applications folder.

c. Set Up PATH (If Required)

To make sure you can run MySQL commands from the terminal without specifying the full path, add this to your .bash_profile, .bashrc, or .zshrc (depending on your shell):

export PATH=${PATH}:/usr/local/mysql/bin

Then, load your updated profile:

source ~/.bash_profile  # or ~/.bashrc or ~/.zshrc

Step 4: Restore Your Data (If You Backed It Up)

mysql -u [username] -p < backup.sql

Replace [username] with your MySQL username.

Step 5: Secure Installation

To ensure your MySQL server is secure:

sudo mysql_secure_installation

Follow the prompts to set a root password and make any other recommended security changes.

Done!

You've successfully reinstalled MySQL on your Mac. Remember to always backup your data before making significant changes, and ensure that any configurations or custom settings are documented so you can recreate them if needed. Happy querying!