fixing issues with homebrew mac mysql

index.md

add tmp directory in my.cnf

tmpdir          = /tmp

Note: Mariadb does not need this.

Grant permissions

sudo chmod 0777 /tmp
sudo chmod 0777 /opt/homebrew/var/mysql/{your_mac_profile}..err
sudo chmod 0777 /opt/homebrew/var/mysql/{your_mac_profile}..pid
chmod 0777 /opt/homebrew/var/{your_mac_profile}..err

lsof /tmp/mysql.sock;
then LOOK for pid, ps -e | grep pid
sudo kill -9 after pid

mysqld login with skip-tables or edit and add to /opt/homebrew/etc/my.cnf [mysqld] \n skip-grant-tables

FLUSH PRIVILEGES;
ALTER USER root@localhost IDENTIFIED VIA mysql_native_password
USING PASSWORD('my secret password');
FLUSH PRIVILEGES;