in my brew I have 2 mysql versions:
mysql installed versions: 5.7.20_1, 8.0.11
I switch to 5.7.20_1
, type mysql.server start
and all good, I can type mysql
hit enter and im in the shell.
now, I switch to 8.0.11
type mysql.server start
and get:
Starting MySQL
.... ERROR! The server quit without updating PID file (/usr/local/var/mysql/My-MBP-2.pid).
I can only start 8.0.11
version with brew services start mysql
but then i dont know how to open its shell...so confused. just wanted to upgrade from 5.7.20_1