Erro de inicialização do servidor Homebrew MariaDB com 'mysql.server start'

Posso reproduzir seu problema. Não use mysql.server startno macOS .

Se você instalou o MariaDB com homebrew, use brew servicespara iniciar e parar o banco de dados. Leva apenas um segundo e não escreve um erro estranho no stdout.

brew services stop mariadb
Stopping `mariadb`... (might take a while)
==> Successfully stopped `mariadb` (label: homebrew.mxcl.mariadb)

brew services start mariadb
==> Successfully started `mariadb` (label: homebrew.mxcl.mariadb)

visão geral dos serviços em homebrew:

brew services list
Name     Status  User     Plist
logstash stopped
mariadb  started Kim /Users/Kim/Library/LaunchAgents/homebrew.mxcl.mariadb.plist
mysql    stopped

ajuda Geral

brew services --help
brew services command:
    Integrates Homebrew formulae with macOS' launchctl manager.

    [sudo] brew services list
    List all running services for the current user (or root)

    [sudo] brew services run formula|--all
    Run the service formula without starting at login (or boot).

    [sudo] brew services start formula|--all
    Start the service formula immediately and register it to launch at login (or boot).

    [sudo] brew services stop formula|--all
    Stop the service formula immediately and unregister it from launching at login (or boot).

    [sudo] brew services restart formula|--all
    Stop (if necessary) and start the service immediately and register it to launch at login (or boot).

    [sudo] brew services cleanup
    Remove all unused services.

    If sudo is passed, operate on /Library/LaunchDaemons (started at boot).
    Otherwise, operate on ~/Library/LaunchAgents (started at login).

Resolvi o problema alterando .my.cnf de:

[client]
user=myname
password=mypwd
database=mydb

para:

[client]
user=myname
password=mypwd

[mysql]
database=mydb