downgrade homebrew installed mysql 8.0 to mysql 5.7 or before.
For now, the homebrew install mysql version 8.0 or later by default, for some reason, I need to use mysql 5.7, but I got some problem, here is a solution.
In my case, firstly I install mysql 8.0, like this
$ brew install mysql // 8.0 is default.
And next I found this, so I unlink it and install 5.7
$ brew unlink mysql
$ brew install firstname.lastname@example.org
But I try anyway, restart or switch other command, the version still 8.0 and I got some error
$ ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
so I figure out some problem, homebrew will take .sock.lock to fetch file, following below doing:
- uninstall mysql and email@example.com by homebrew
- negative to /tmp remove mysql.sock and mysql.sock.lock
- reinstall firstname.lastname@example.org
- service start
Following the description add path to
It’ should be working, cheers.😋