Comments - MariaDB(10.4.11) Permission Issues on OSX Catalina (10.15.3)

3 years, 9 months ago Brian Pohl

After trying a few different things and a re-install of Homebrew as well as MariaDB, I’m in a spot now where I get an access denied error (see below) when I try and login through iTerm/Terminal with mysql -uroot however using sudo mysql -uroot I can get in. I can run commands to create database after I login with the sudo prefix, however those DBs aren’t accessible via any of my projects through usr/pwd validation through the .env file for Laravel and wp-config.php for Wordpress.

This leads me to believe its a permissions error and I need to somehow adjust the MariaDB/MySQL package so that my OS X user has permission to read/write/execute opposed to just root.

Just wanted to post an update, hopefully circling in on resolution…

➜  ~ mysql -uroot
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
3 years, 6 months ago Brett Tofel

Brian's note made me try my local username (output of `whoami`) and sure enough that's what logged me it as opposed to what the docs say here:

But then what of root permissions for this install path?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.