I am trying to learn SQL this summer and wanted to set up mySQL to do so. I originally downloaded/installed the 8.4.0 version of mySQL on my Mac because it was the newest but I did not realize that it was incompatible with the latest version of mySQL workbench.

I tried to uninstall 8.4.0 and then reinstall the correct version for workbench (8.0.37).

mysql –version in the terminal shows that I am running 8.0.37 but when I run mysql -u root -p it shows 8.4.0. Workbench also detects the 8.4.0 version as opposed to the 8.0.37.

I am running on an ARM Mac (M2 Max) to be precise.

I tried uninstalling and reinstalling, I updated the .zshrc file many times and I even dabbled with rm -rf to completely remove the mysql directories, nothing worked.