The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

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

I'm setting up a new machine for development w/ OS X Catalina (10.15.3) and having issues with MariaDB/MySQL permissions. I installed Homebrew and then installed the MariaDB package. After logging in using mysql -uroot , I get the following error when trying to create a database:

➜  ~ mysql -uroot
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 12
Server version: 10.4.11-MariaDB Homebrew

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database anything_db;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'anything_db'

where 'anything_db' is any database that I try to create. From reading the error, it looks like it's interpreting my command as being run from not root, but instead an anonymous user (I think that's what '' means in that context). However, when I run status at the MySQL command prompt, it outputs the following:

MariaDB [(none)]> status
--------------
mysql  Ver 15.1 Distrib 10.4.11-MariaDB, for osx10.15 (x86_64) using readline 5.1

Connection id:		12
Current database:
Current user:		root@localhost
SSL:			Not in use
Current pager:		less
Using outfile:		''
Using delimiter:	;
Server:			MariaDB
Server version:		10.4.11-MariaDB Homebrew
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	utf8mb4
Db     characterset:	utf8mb4
Client characterset:	utf8
Conn.  characterset:	utf8
UNIX socket:		/tmp/mysql.sock
Uptime:			18 hours 5 min 23 sec

Threads: 7  Questions: 25  Slow queries: 0  Opens: 16  Flush tables: 1  Open tables: 10  Queries per second avg: 0.000
--------------

This seems to suggest it's registering me being logged in as root@localhost but that is not what the previously listed error seems to suggest. Is it a permissions related error? I don't think I missed any sudo prefixes while going through the installs, but it seems like that could be related.

This has always "just worked" for me when setting up/re-formatting my dev machines so this is my first time having to dig in. Any help is great appreciated and let me know if any more info would be helpful. Thanks in advance for any advice!

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.