trying to install and use mysql with homebrew turns into the following error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

[marcosdipaolo]

Output of brew config

HOMEBREW_VERSION: 4.4.8
ORIGIN: https://github.com/Homebrew/brew
HEAD: e78a0adb4f260913fffdc956cc8c20fb54109feb
Last commit: 29 hours ago
Branch: stable
Core tap JSON: 26 Nov 22:15 UTC
Core cask tap JSON: 26 Nov 22:15 UTC
HOMEBREW_PREFIX: /opt/homebrew
HOMEBREW_CASK_OPTS: []
HOMEBREW_MAKE_JOBS: 11
Homebrew Ruby: 3.3.6 => /opt/homebrew/Library/Homebrew/vendor/portable-ruby/3.3.6/bin/ruby
CPU: 11-core 64-bit arm_lobos
Clang: 16.0.0 build 1600
Git: 2.39.5 => /Library/Developer/CommandLineTools/usr/bin/git
Curl: 8.7.1 => /usr/bin/curl
macOS: 15.1.1-arm64
CLT: 16.1.0.0.1.1729049160
Xcode: N/A
Rosetta 2: false

Output of brew doctor

Your system is ready to brew.

Description of issue

Everything started when I installed mysql and then realized that I needed a slightly earlier version (8.0). Thenm I uninstalled mysql and installed mysql@8.0.

Now it does not matter what I install. If I go mysql I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
If I run mysql.server start I get ERROR! The server quit without updating PID file (/opt/homebrew/var/mysql/Marcoss-MacBook-Pro.local.pid).
If I cat /opt/homebrew/etc/my.cnf I get:

# Default Homebrew MySQL server config
[mysqld]
# Only allow connections from localhost
bind-address = 127.0.0.1
mysqlx-bind-address = 127.0.0.1

If I cat /opt/homebrew/var/mysql/Marcoss-MacBook-Pro.local.err I get

.................................
2024-11-26T22:39:04.6NZ mysqld_safe Logging to '/opt/homebrew/var/mysql/Marcoss-MacBook-Pro.local.err'.
2024-11-26T22:39:04.6NZ mysqld_safe Starting mysqld daemon with databases from /opt/homebrew/var/mysql
2024-11-26T22:39:04.435696Z 0 [System] [MY-010116] [Server] /opt/homebrew/opt/mysql@8.0/bin/mysqld (mysqld 8.0.40) starting as process 45078
2024-11-26T22:39:04.436690Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /opt/homebrew/var/mysql/ is case insensitive
2024-11-26T22:39:04.440323Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2024-11-26T22:39:04.440357Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-11-26T22:39:04.440369Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-11-26T22:39:04.440509Z 0 [System] [MY-010910] [Server] /opt/homebrew/opt/mysql@8.0/bin/mysqld: Shutdown complete (mysqld 8.0.40)  Homebrew.
2024-11-26T22:39:04.6NZ mysqld_safe mysqld from pid file /opt/homebrew/var/mysql/Marcoss-MacBook-Pro.local.pid ended

If I go brew services list I get (after brew services start mysql@8.0):

Name    Status  User          File
mysql   stopped marcosdipaolo ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
openvpn none
php     none

All of this with mysql and mysql@8.0

Not sure what I broke.

Thanks a lot for your help.

[gromgit]

What's the output of brew info mysql mysql@8.0?

[marcosdipaolo]

==> mysql: stable 9.0.1 (bottled)
Open source relational database management system
https://dev.mysql.com/doc/refman/9.0/en/
Conflicts with:
  mariadb (because both install the same binaries)
  percona-server (because both install the same binaries)
Not installed
Bottle Size: 80.7MB
Installed Size: 308.8MB
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/m/mysql.rb
License: GPL-2.0-only WITH Universal-FOSS-exception-1.0
==> Dependencies
Build: bison ✘, cmake ✘, pkgconf ✘
Required: abseil ✔, icu4c@76 ✔, lz4 ✔, openssl@3 ✔, protobuf ✔, zlib ✔, zstd ✔
==> Caveats
Upgrading from MySQL <8.4 to MySQL >9.0 requires running MySQL 8.4 first:
 - brew services stop mysql
 - brew install mysql@8.4
 - brew services start mysql@8.4
 - brew services stop mysql@8.4
 - brew services start mysql

We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -u root

To restart mysql after an upgrade:
  brew services restart mysql
Or, if you don't want/need a background service you can just run:
  /opt/homebrew/opt/mysql/bin/mysqld_safe --datadir\=/opt/homebrew/var/mysql
==> Analytics
install: 52,746 (30 days), 175,011 (90 days), 561,296 (365 days)
install-on-request: 52,706 (30 days), 174,816 (90 days), 560,127 (365 days)
build-error: 622 (30 days)

==> mysql@8.0: stable 8.0.40 (bottled) [keg-only]
Open source relational database management system
https://dev.mysql.com/doc/refman/8.0/en/
Installed
/opt/homebrew/Cellar/mysql@8.0/8.0.40_2 (319 files, 303.7MB)
  Poured from bottle using the formulae.brew.sh API on 2024-11-26 at 19:37:05
From: https://github.com/Homebrew/homebrew-core/blob/HEAD/Formula/m/mysql@8.0.rb
License: GPL-2.0-only WITH Universal-FOSS-exception-1.0
==> Dependencies
Build: bison ✘, cmake ✘, pkgconf ✘
Required: abseil ✔, icu4c@76 ✔, libevent ✔, libfido2 ✔, lz4 ✔, openssl@3 ✔, protobuf ✔, zlib ✔, zstd ✔
==> Caveats
We've installed your MySQL database without a root password. To secure it run:
    mysql_secure_installation

MySQL is configured to only allow connections from localhost by default

To connect run:
    mysql -u root

mysql@8.0 is keg-only, which means it was not symlinked into /opt/homebrew,
because this is an alternate version of another formula.

If you need to have mysql@8.0 first in your PATH, run:
  echo 'export PATH="/opt/homebrew/opt/mysql@8.0/bin:$PATH"' >> ~/.zshrc

For compilers to find mysql@8.0 you may need to set:
  export LDFLAGS="-L/opt/homebrew/opt/mysql@8.0/lib"
  export CPPFLAGS="-I/opt/homebrew/opt/mysql@8.0/include"

To restart mysql@8.0 after an upgrade:
  brew services restart mysql@8.0
Or, if you don't want/need a background service you can just run:
  /opt/homebrew/opt/mysql@8.0/bin/mysqld_safe --datadir\=/opt/homebrew/var/mysql
==> Analytics
install: 9,070 (30 days), 28,209 (90 days), 63,729 (365 days)
install-on-request: 9,065 (30 days), 28,198 (90 days), 63,642 (365 days)
build-error: 85 (30 days)

[cho-m]

May be worth manually running foreground command with higher logging level to see if it outputs information on what is exact reason. The current logs oddly claim to use the dir and then claim it can't find the dir:

2024-11-26T22:39:04.436690Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /opt/homebrew/var/mysql/ is case insensitive
2024-11-26T22:39:04.440323Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.

Could also check is if there is a running process for prior MySQL in ps or Activity Monitor.

---

Without additional information, only possibility I can think of is the MySQL 9 initialized DB at /opt/homebrew/var/mysql is incompatible with MySQL 8.0.

If you don't have any data already stored, then can try deleting it and running brew postinstall mysql@8.0.

[marcosdipaolo]

MySQL 9 initialized DB at /opt/homebrew/var/mysql is incompatible with MySQL 8.0. If you don't have any data already stored, try deleting it and running brew postinstall mysql@8.0.

That saved my ass.

Thanks a lot @cho-m