Reset MySQL root password (Homebrew)

homebrew_mysql_pass_reset.txt

$> launchctl unload -w ~/Library/LaunchAgents/com.mysql.mysqld.plist

$> /usr/local/Cellar/mysql/5.5.9/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.5.9 --datadir=/usr/local/Cellar/mysql/5.5.9/data --plugin-dir=/usr/local/Cellar/mysql/5.5.9/lib/plugin --log-error=/usr/local/Cellar/mysql/5.5.9/data/errors.err --pid-file=/usr/local/Cellar/mysql/5.5.9/data/pidfile.pid --skip-grant-tables

$> mysql

mysql> UPDATE mysql.user SET Password=PASSWORD('root_password') WHERE User='root';
mysql> FLUSH PRIVILEGES;

$> kill `cat /usr/local/Cellar/mysql/5.5.9/data/pidfile.pid`

$> ps auwx | grep mysql

$> launchctl load -w ~/Library/LaunchAgents/com.mysql.mysqld.plist

$ brew services stop mysql
$ pkill mysqld
$ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!!
$ brew postinstall mysql
$ brew services restart mysql
$ mysql -uroot

this work perfectly for me
@imamalys THANK YOU!!!

Everytime I restart my system, I will have to re-do these steps to work with mysql! Is there a way I can make this a permanent change?

brew services restart mysql

thanks for this. it worked for me

/opt/homebrew/opt/mysql/bin/mysqld_safe --datadir=/opt/homebrew/var/mysql to run safe server

Everytime I restart my system, I will have to re-do these steps to work with mysql! Is there a way I can make this a permanent change?

@rajeswarivmarimuthu Did you ever figure out what is causing this? mine is doing the same thing

$ brew services stop mysql $ pkill mysqld $ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!! $ brew postinstall mysql $ brew services restart mysql $ mysql -uroot

this work perfectly for me @imamalys THANK YOU!!!

Not working form me in macOS Sonoma 14.1.1
Any other solution?

$ brew services stop mysql $ pkill mysqld $ rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!! $ brew postinstall mysql $ brew services restart mysql $ mysql -uroot
this work perfectly for me @imamalys THANK YOU!!!

Not working form me in macOS Sonoma 14.1.1 Any other solution?

try this, It's works for me :)

https://aungzanbaw.medium.com/how-to-reset-root-user-password-in-mysql-8-0-a5c328d098a8