macOS X 15.7 brew安装mariadb 记录RuntimeError

macOS X 15.7 brew安装mariadb

新环境

新环境需要安装的组件很多

==> Fetching dependencies for mariadb: mecab, mecab-ipadic, cmake, msgpack, ca-certificates, openssl@3, groonga pcre2 lz4 xz zstd bison fmt

手动逐步安装 只留zstd

…

安装mariadb

like@likes-iMac homebrew-cask % brew install mariadb
Warning: You are using macOS 10.15.
We (and Apple) do not provide support for this old version.
It is expected behaviour that some formulae will fail to build in this old version.
It is expected behaviour that Homebrew will be buggy and slow.
Do not create any issues about this on Homebrew’s GitHub repositories.
Do not create any issues even if you think this message is unrelated.
Any opened issues will be immediately closed without response.
Do not ask for help from Homebrew or its maintainers on social media.
You may ask for help in Homebrew’s discussions but are unlikely to receive a response.
Try to figure out the problem yourself and submit a fix as a pull request.
We will review it but may or may not accept it.

==> Fetching dependencies for mariadb: zstd
==> Fetching zstd
==> Downloading https://raw.githubusercontent.com/Homebrew/homebrew-core/6b3ce016a5a98cb368a176a5fd602858d4
#################################################################################################### 100.0%
==> Downloading https://github.com/facebook/zstd/archive/refs/tags/v1.5.5.tar.gz
Already downloaded: /Users/like/Library/Caches/Homebrew/downloads/0f2c3a8e3bcdef06ea1d1bcbf0cc6fe334726af8b5984cd6dd76a4f6d4d7b896–v1.5.5.tar.gz
==> Fetching mariadb
==> Downloading https://raw.githubusercontent.com/Homebrew/homebrew-core/6b3ce016a5a98cb368a176a5fd602858d4
#################################################################################################### 100.0%
==> Downloading https://github.com/MariaDB/server/commit/3624a36aed0346380255b141cb8a59998aaca4ee.patch?ful
Already downloaded: /Users/like/Library/Caches/Homebrew/downloads/9219725d44f9bbb7476f5d33488ef4e720a7079482e06adc97b9ca0777c015e8–3624a36aed0346380255b141cb8a59998aaca4ee.patch
==> Downloading https://archive.mariadb.org/mariadb-11.3.2/source/mariadb-11.3.2.tar.gz
Already downloaded: /Users/like/Library/Caches/Homebrew/downloads/0826e5fb192ac7d9de69109d0848f318ac6c0b7e0f07da05a9391a50a12de31f–mariadb-11.3.2.tar.gz
==> Installing dependencies for mariadb: zstd
==> Installing mariadb dependency: zstd
Error: An exception occurred within a child process:
RuntimeError: /usr/local/opt/lz4 not present or broken
Please reinstall lz4. Sorry 😦

去掉提示的lz4RuntimeError

brew uninstall lz4

再次安装mariadb

brew install mariadb

==> Installing dependencies for mariadb: lz4 and zstd
==> Installing mariadb dependency: lz4
==> Pouring lz4-1.9.4.catalina.bottle.tar.gz
🍺 /usr/local/Cellar/lz4/1.9.4: 22 files, 680.2KB

==> Installing mariadb dependency: zstd
==> cmake -S build/cmake -B builddir -DZSTD_PROGRAMS_LINK_SHARED=ON -DZSTD_BUILD_CONTRIB=ON -DCMAKE_INSTALL
==> cmake --build builddir
==> cmake --install builddir
🍺 /usr/local/Cellar/zstd/1.5.5: 31 files, 2.5MB, built in 27 seconds
==> Installing mariadb
==> Patching
==> Applying 3624a36aed0346380255b141cb8a59998aaca4ee.patch
==> Summary
🍺 /usr/local/Cellar/mariadb/11.3.2: 950 files, 228.6MB, built in 12 minutes 33 seconds
==> Running brew cleanup mariadb…

启动MariaDB:

brew services start mariadb

MariaDB运行信息:

brew services info mariadb

简单安全配置

mysql_secure_installation

进入 mysql

执行测试

create database macdb default charset ‘utf8’;

正常
MariaDB> show create database macdb;