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.

Thanks! You saved me.

Worked. This was helpful. Thanks.

Thanks for this. Setting up a new laptop and this is helping a lot.

Thanks !!

Thanks a lot. For all the new users trying to change the password, please use the keyword mariadb instead of mysql in the above command.

thank you, either using mariadb or mysql works

This saved my life

Worked, Thanks !

Worked beautifully!

This is was very helpful. Thanks a lot!

Thanks!

Worked like a charm. Thanks

Thanks kbs.

Thanks for this. How do I bookmark this in GitHub ?

谢谢你!这真的很有用!!太酷了~

Thanks. This has helped me.

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!