Mysql 8 update via brew (Magento 2)

mysql_update.sh

# Update all dependencies via brew
brew update
brew upgrade

# validate php
php -v
# When problems re-occur fix them first. I had to run 'brew reinstall icu4c' because my icu4c dependency was missing.

# Remove mysql 5.7
brew services stop [email protected]
brew remove [email protected]
mv /usr/local/var/mysql /usr/local/var/mysql.backup
 mv /usr/local/etc/my.cnf /usr/local/etc/my.cnf.backup

# Install mysql 8
brew install mysql

# Verify mysql 8 installation
mysql -V # Should return v8
netstat -ln | grep mysql # There should be a mysql socket running
mysql

# Set password 'root'
mysql_secure_installation

# Check mysql access
mysql -uroot proot

# Try creating a db for a project using magerun2
n98-magerun2 db:create
# Resulted in an error: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
# To fix this checkout https://magento.stackexchange.com/a/318612/28803
# Now retry creating the db.
n98-magerun2 db:import --compression="gzip" your_db.sql.gz
n98-mnagerun2 setup:upgrade
# Validate the frontend

# Fix 'mysql' command on command line
nano /usr/local/etc/my.cnf
# Add:
#
# [client]
# user=root
# password=root