Skip to content

Instantly share code, notes, and snippets.

@JuanLuisGarciaBorrego

JuanLuisGarciaBorrego/mariadb-brew-macos.md

Forked from nickcernis/mariadb-brew-macos.md
Created August 3, 2022 10:43
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save JuanLuisGarciaBorrego/0760b6d4ca400a05be964d331fe0a0bc to your computer and use it in GitHub Desktop.
Save JuanLuisGarciaBorrego/0760b6d4ca400a05be964d331fe0a0bc 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):

  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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment