Completely do away with MySQL dependencies after migrating to MariaDB

From: Washington Odhiambo <odhiambo_at_gmail.com>
Date: Fri, 19 Dec 2025 11:49:25 UTC
I my /etc/make.conf, I have:
DEFAULT_VERSIONS+= python=3.11 python3=3.11 pgsql=15 ssl=openssl
mysql=11.4m mariadb=11.4

I still suffer from some pkgs wanting to install MySQL client libraries by
force :-)

How do I stop them once and for all?


root@gw:/home/wash # pkg upgrade
Updating FreeBSD-ports-kmods repository catalogue...
Fetching data.pkg: 100%   34 KiB  35.1kB/s    00:01
Processing entries: 100%
FreeBSD-ports-kmods repository update completed. 238 packages processed.
Updating FreeBSD-base repository catalogue...
Fetching data.pkg: 100%   80 KiB  81.5kB/s    00:01
Processing entries: 100%
FreeBSD-base repository update completed. 496 packages processed.
Updating FreeBSD-ports repository catalogue...
Fetching data.pkg: 100%   11 MiB   2.8MB/s    00:04
Processing entries: 100%
FreeBSD-ports repository update completed. 36978 packages processed.
All repositories are up to date.
Checking for upgrades (84 candidates): 100%
Processing candidates (84 candidates): 100%
The following 85 package(s) will be affected (of 0 checked):

New packages to be INSTALLED:
        mysql80-client: 8.0.44 [FreeBSD-ports]
        p5-DBD-mysql: 5.008 [FreeBSD-ports]

Installed packages to be UPGRADED:
        FreeBSD-kernel-generic: 15.0 -> 15.0p1 [FreeBSD-base]
        FreeBSD-rescue: 15.0 -> 15.0p1 [FreeBSD-base]
        FreeBSD-runtime: 15.0 -> 15.0p1 [FreeBSD-base]
        FreeBSD-src: 15.0 -> 15.0p1 [FreeBSD-base]
        FreeBSD-src-sys: 14.2 -> 15.0p1 [FreeBSD-base]
        FreeBSD-utilities: 15.0 -> 15.0p1 [FreeBSD-base]
        apache24: 2.4.65_1 -> 2.4.66 [FreeBSD-ports]
        autoconf: 2.72 -> 2.72_1 [FreeBSD-ports]
        automake: 1.17 -> 1.18.1 [FreeBSD-ports]
        bash: 5.3.8_1 -> 5.3.9 [FreeBSD-ports]
        bastille: 1.2.0.251201 -> 1.2.2.251204 [FreeBSD-ports]
        c-ares: 1.34.5 -> 1.34.6 [FreeBSD-ports]
        cmake: 3.31.9 -> 3.31.10 [FreeBSD-ports]
        cmake-core: 3.31.9 -> 3.31.10 [FreeBSD-ports]
        cmake-doc: 3.31.9 -> 3.31.10 [FreeBSD-ports]
        cmake-man: 3.31.9 -> 3.31.10 [FreeBSD-ports]
        compat14x-amd64: 14.2.1402000.20251120 -> 14.2.1402000.20251120_1
[FreeBSD-ports]
        crowdsec: 1.7.3_2 -> 1.7.4 [FreeBSD-ports]
        cups: 2.4.15_1 -> 2.4.16 [FreeBSD-ports]
        dav1d: 1.5.1_1 -> 1.5.2 [FreeBSD-ports]
        fontconfig: 2.15.0_3,1 -> 2.17.1,1 [FreeBSD-ports]
        gettext-runtime: 0.23.1 -> 0.26 [FreeBSD-ports]
        gettext-tools: 0.23.1_1 -> 0.26 [FreeBSD-ports]
        ghostscript10: 10.06.0 -> 10.06.0_1 [FreeBSD-ports]
        git: 2.51.2 -> 2.52.0 [FreeBSD-ports]
        glslang: 16.0.0 -> 16.1.0 [FreeBSD-ports]
        graphviz: 14.0.5 -> 14.0.5_1 [FreeBSD-ports]
        gstreamer1: 1.26.8 -> 1.26.9 [FreeBSD-ports]
        harfbuzz: 10.3.0 -> 12.2.0 [FreeBSD-ports]
        harfbuzz-icu: 10.3.0 -> 12.2.0 [FreeBSD-ports]
        hwdata: 0.401,1 -> 0.402,1 [FreeBSD-ports]
        libatomic_ops: 7.8.0 -> 7.10.0 [FreeBSD-ports]
        libdatrie: 0.2.14 -> 0.2.14_1 [FreeBSD-ports]
        libdrm: 2.4.123,1 -> 2.4.131,1 [FreeBSD-ports]
        libgit2: 1.9.1 -> 1.9.2 [FreeBSD-ports]
        libgpg-error: 1.56 -> 1.58 [FreeBSD-ports]
        libgsf: 1.14.53_1 -> 1.14.54 [FreeBSD-ports]
        libtextstyle: 0.23.1 -> 0.26 [FreeBSD-ports]
        libthai: 0.1.29_1 -> 0.1.29_2 [FreeBSD-ports]
        libzip: 1.11.2 -> 1.11.4 [FreeBSD-ports]
        luajit: 2.1.0.20251116 -> 2.1.0.20251208 [FreeBSD-ports]
        nss: 3.118.1 -> 3.119.1 [FreeBSD-ports]
        nushell: 0.108.0_1 -> 0.109.1 [FreeBSD-ports]
        oath-toolkit: 2.6.9_2 -> 2.6.13 [FreeBSD-ports]
        openjdk18: 18.0.2+9.1_4 -> 18.0.2+9.1_5 [FreeBSD-ports]
        openjdk19: 19.0.2+7.1_3 -> 19.0.2+7.1_4 [FreeBSD-ports]
        openjdk20: 20.0.2+9.1_2 -> 20.0.2+9.1_3 [FreeBSD-ports]
        openjpeg: 2.5.4 -> 2.5.4_1 [FreeBSD-ports]
        pciids: 20251130 -> 20251206 [FreeBSD-ports]
        pinentry: 1.3.2 -> 1.3.2_1 [FreeBSD-ports]
        png: 1.6.50 -> 1.6.52 [FreeBSD-ports]
        poppler: 25.04.0_2 -> 25.10.0 [FreeBSD-ports]
        poppler-glib: 25.04.0_2 -> 25.10.0 [FreeBSD-ports]
        public_suffix_list: 20251117 -> 20251204 [FreeBSD-ports]
        py311-gi-docgen: 2025.4 -> 2025.5 [FreeBSD-ports]
        py311-greenlet: 3.2.4 -> 3.3.0 [FreeBSD-ports]
        py311-pdftotext: 3.0.0_3 -> 3.0.0_4 [FreeBSD-ports]
        py311-platformdirs: 4.5.0 -> 4.5.1 [FreeBSD-ports]
        py311-psycopg-pool: 3.2.8 -> 3.3.0 [FreeBSD-ports]
        py311-publicsuffix2: 2.20191221_70 -> 2.20191221_71 [FreeBSD-ports]
        py311-python-socks: 2.7.3 -> 2.8.0 [FreeBSD-ports]
        py311-rpds-py: 0.29.0 -> 0.30.0 [FreeBSD-ports]
        py311-trove-classifiers: 2025.11.14.15 -> 2025.12.1.14
[FreeBSD-ports]
        py311-urllib3: 2.5.0,1 -> 2.6.0,1 [FreeBSD-ports]
        pylint-py311: 4.0.3 -> 4.0.4 [FreeBSD-ports]
        qemu-guest-agent: 10.1.2_1 -> 10.1.3 [FreeBSD-ports]
        redis: 8.4.0 -> 8.4.0_1 [FreeBSD-ports]
        rubygem-iconv: 1.1.0 -> 1.1.1 [FreeBSD-ports]
        rubygem-json: 2.16.0 -> 2.17.1 [FreeBSD-ports]
        rubygem-pkg-config: 1.6.4 -> 1.6.5 [FreeBSD-ports]
        rubygem-public_suffix: 7.0.0 -> 7.0.0_1 [FreeBSD-ports]
        rubygem-rubocop-rails: 2.34.1 -> 2.34.2 [FreeBSD-ports]
        rubygem-sqlite3: 2.8.0 -> 2.8.1 [FreeBSD-ports]
        rubygem-stringio: 3.1.8 -> 3.1.9 [FreeBSD-ports]
        texinfo: 7.2_2,1 -> 7.2_3,1 [FreeBSD-ports]
        texlive-base: 20250308_2 -> 20250308_3 [FreeBSD-ports]
        vips: 8.17.3 -> 8.17.3_1 [FreeBSD-ports]

Installed packages to be REINSTALLED:
        opendmarc-1.4.2_4 [FreeBSD-ports] (options changed)
        p5-DBD-MariaDB-1.23 [FreeBSD-ports] (direct dependency changed:
mysql80-client)
        p5-DBD-mysql4-4.052 [FreeBSD-ports] (direct dependency changed:
mysql80-client)
        pure-ftpd-1.0.52_1 [FreeBSD-ports] (options changed)
        sogo-mysql-5.12.4 [FreeBSD-ports] (options changed)
        sope-mysql-5.12.4 [FreeBSD-ports] (direct dependency changed:
mysql80-client)

Number of packages to be installed: 2
Number of packages to be upgraded: 77
Number of packages to be reinstalled: 6

The process will require 120 MiB more space.
985 MiB to be downloaded.

Proceed with this action? [y/N]:

-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
 In an Internet failure case, the #1 suspect is a constant: DNS.
"Oh, the cruft.", egrep -v '^$|^.*#' ¯\_(ツ)_/¯ :-)
[How to ask smart questions:
http://www.catb.org/~esr/faqs/smart-questions.html]