Install MariaDB with brew on macOS and fix the “access denied” issue

mariadb-brew-macos.md

Attempting mysql -u root fails with Access denied for user 'root'@'localhost immediately after doing brew install mariadb and starting mariadb with brew services start mariadb.

To fix it (with MariaDB still running):

1. sudo mysql then enter your Mac user password
2. ALTER USER 'root'@'localhost' IDENTIFIED BY 'newrootpassword'; replacing newrootpassword with the password you wish to use for the MariaDB root user.
3. Ctrl-C to exit mysql.

You should then be able to connect to MariaDB with mysql -u root -p, then entering the root password when prompted.

Man is a life saver!

Hero !!

If it is still not working for someone, then the root username is the same as the Mac user.

Thank you so much, it work on me

Saved my day!

Thanks !

👍

Thank you so much. I was stuck on this bug for hours and this is the only thing that worked!

Thanks for the hint. Ended up withALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPassword'; flush privileges; exit;.

thanks Nick, you saved me! 👍

Thanks alot

Thanks
At first, i don't believe a reset is needed after a new installation. But i really hard reset it over years. I wont past the relative commands i used to prevent misleading
useful knowledges increased.

Thanks a lot !!
Still good - even four years later ... 😅

cool!