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 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!