mwangaben/mariadb-brew-macos.md

Forked from nickcernis/mariadb-brew-macos.md

Created August 6, 2024 02:08

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mwangaben/2bb409ca92047bb12a73c14a013caeb1.js"></script>
Save mwangaben/2bb409ca92047bb12a73c14a013caeb1 to your computer and use it in GitHub Desktop.

Download ZIP

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

Raw

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):

sudo mysql then enter your Mac user password
ALTER USER 'root'@'localhost' IDENTIFIED BY 'newrootpassword'; replacing newrootpassword with the password you wish to use for the MariaDB root user.
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.