Cannot login into MariaDB with brew after restarting the machine

[Victorcorcos]

Output of brew config

$ brew config
HOMEBREW_VERSION: 4.3.10
ORIGIN: https://github.com/Homebrew/brew
HEAD: c3ae0327c01aab461531bfc0fcdfb4dd3a779205
Last commit: 5 days ago
Core tap JSON: 22 Jul 17:18 UTC
Core cask tap JSON: 22 Jul 17:18 UTC
HOMEBREW_PREFIX: /opt/homebrew
HOMEBREW_CASK_OPTS: []
HOMEBREW_EDITOR: vi
HOMEBREW_MAKE_JOBS: 16
Homebrew Ruby: 3.3.3 => /opt/homebrew/Library/Homebrew/vendor/portable-ruby/3.3.3/bin/ruby
CPU: 16-core 64-bit arm_palma
Clang: 15.0.0 build 1500
Git: 2.39.3 => /Applications/Xcode.app/Contents/Developer/usr/bin/git
Curl: 8.6.0 => /usr/bin/curl
macOS: 14.5-arm64
CLT: 15.3.0.0.1.1708646388
Xcode: 15.4
Rosetta 2: false

Output of brew doctor

$ brew doctor
Please note that these warnings are just used to help the Homebrew maintainers
with debugging if you file an issue. If everything you use Homebrew for is
working fine: please don't worry or file an issue; just ignore this. Thanks!

Warning: Some installed casks are deprecated or disabled.
You should find replacements for the following casks:
  meld

Warning: Some installed formulae are deprecated or disabled.
You should find replacements for the following formulae:
  openssl@1.1

Warning: You have unlinked kegs in your Cellar.
Leaving kegs unlinked can lead to build-trouble and cause formulae that depend on
those kegs to fail to run properly once built. Run `brew link` on these:
  mariadb-connector-c

Description of issue

I'm using MacOS Sonoma 14.5 and I had installed mariadb using brew successfully. However, when I execute

mariadb -uroot -password

It is returning

ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)

I searched online and the solution to this would be to generate a mysql.sock file by executing

brew services start mariadb
# OR brew services restart mariadb

However, I tried it, as you can see below:

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

Still, not any mysql.sock file is generated inside the /tmp folder and I can't login in the mariadb database.

victorcosta@Victors-MacBook-Pro:/tmp $ cd /tmp
victorcosta@Victors-MacBook-Pro:/tmp $ ls
com.apple.launchd.6mj6GfdTiF powerlog

So, how can I connect to mariadb with mysql -uroot -ppassword using brew?

[SMillerDev]

What happens if you run the command in brew info mariadb instead of the service?

[Victorcorcos]

Hi there! This hapens:

$ brew info mariadb
==> mariadb: stable 11.4.2 (bottled)
Drop-in replacement for MySQL
https://mariadb.org/
Conflicts with:
  mariadb-connector-c (because both install `mariadb_config`)
  mysql (because mariadb, mysql, and percona install the same binaries)
  mytop (because both install `mytop` binaries)
  percona-server (because mariadb, mysql, and percona install the same binaries)
Installed
/opt/homebrew/Cellar/mariadb/11.4.2 (945 files, 211.9MB) *
  Poured from bottle using the formulae.brew.sh API on 2024-07-19 at 13:33:47
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/m/mariadb.rb
License: GPL-2.0-only
==> Dependencies
Build: bison ✔, cmake ✘, fmt ✔, pkg-config ✔
Required: groonga ✔, lz4 ✔, openssl@3 ✔, pcre2 ✔, xz ✘, zstd ✔
==> Caveats
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.

MySQL is configured to only allow connections from localhost by default

To restart mariadb after an upgrade:
  brew services restart mariadb
Or, if you don't want/need a background service you can just run:
  /opt/homebrew/opt/mariadb/bin/mariadbd-safe --datadir\=/opt/homebrew/var/mysql
==> Analytics
install: 9,039 (30 days), 22,449 (90 days), 83,340 (365 days)
install-on-request: 9,015 (30 days), 22,353 (90 days), 82,225 (365 days)
build-error: 32 (30 days)

[SMillerDev]

Yeah, so the command that's in that output:

/opt/homebrew/opt/mariadb/bin/mariadbd-safe --datadir=/opt/homebrew/var/mysql

What happens when you run that?

[Victorcorcos]

@SMillerDev

Here it is:

$ /opt/homebrew/opt/mariadb/bin/mariadbd-safe --datadir=/opt/homebrew/var/mysql
240724 00:27:07 mysqld_safe Logging to '/opt/homebrew/var/mysql/Victors-MacBook-Pro.local.err'.
240724 00:27:07 mysqld_safe Starting mariadbd daemon with databases from /opt/homebrew/var/mysql

Still, no mysql.lock file is generated in /tmp

$ ls
com.apple.launchd.6IqPjq0LYA powerlog

[anjanesh]

This is a recurring issue - I just upgraded from Sonoma to Sequoia and am experiencing the same issue as described here.
This seems to happen with every laptop re-start.

anjanesh-m2@Anjaneshs-MacBook-Air ~ % mariadb --user=root -p  
Enter password: 
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
anjanesh-m2@Anjaneshs-MacBook-Air ~ % brew info mariadb
==> mariadb: stable 11.5.2 (bottled)
Drop-in replacement for MySQL
https://mariadb.org/
Conflicts with:
  mariadb-connector-c (because both install `mariadb_config`)
  mysql (because mariadb, mysql, and percona install the same binaries)
  mytop (because both install `mytop` binaries)
  percona-server (because mariadb, mysql, and percona install the same binaries)
Installed
/opt/homebrew/Cellar/mariadb/11.5.2 (948 files, 212.9MB) *
  Poured from bottle using the formulae.brew.sh API on 2024-09-17 at 06:47:29
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/m/mariadb.rb
License: GPL-2.0-only
==> Dependencies
Build: bison ✘, cmake ✘, fmt ✘, pkg-config ✔, openjdk ✘
Required: groonga ✔, lz4 ✔, lzo ✔, openssl@3 ✔, pcre2 ✔, xz ✔, zstd ✔
==> Caveats
A "/etc/my.cnf" from another install may interfere with a Homebrew-built
server starting up correctly.

MySQL is configured to only allow connections from localhost by default

To restart mariadb after an upgrade:
  brew services restart mariadb
Or, if you don't want/need a background service you can just run:
  /opt/homebrew/opt/mariadb/bin/mariadbd-safe --datadir\=/opt/homebrew/var/mysql
==> Analytics
install: 6,361 (30 days), 24,781 (90 days), 87,658 (365 days)
install-on-request: 6,309 (30 days), 24,628 (90 days), 86,664 (365 days)
build-error: 1 (30 days)
anjanesh-m2@Anjaneshs-MacBook-Air ~ % cat /etc/my.cnf
cat: /etc/my.cnf: No such file or directory
anjanesh-m2@Anjaneshs-MacBook-Air ~ % /opt/homebrew/opt/mariadb/bin/mariadbd-safe --datadir=/opt/homebrew/var/mysql


241014 22:05:41 mysqld_safe Logging to '/opt/homebrew/var/mysql/Anjaneshs-MacBook-Air.local.err'.
241014 22:05:41 mysqld_safe Starting mariadbd daemon with databases from /opt/homebrew/var/mysql
anjanesh-m2@Anjaneshs-MacBook-Air ~ % mariadb --user=root -p                                                       
Enter password: 
ERROR 2002 (HY000): Can't connect to local server through socket '/tmp/mysql.sock' (2)
anjanesh-m2@Anjaneshs-MacBook-Air ~ %