Using brew to install MariaDB:
brew install mariadb
To manage the service use ‘brew services’ e.g
brew services restart mariadb
Notice that the install ran the following:
/opt/homebrew/Cellar/mariadb/10.8.3/bin/mysql_install_db --verbose --user=jonny ...
So connect to MariaDB as your Mac user e.g.
mariadb -u jonny -p
I used my mac user password. Or just with the mysql command e.g.