git: 7197a9cc5dc8 - main - databases/mysql267-{server|client}: Add New Port
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Mon, 12 Oct 2026 19:46:09 UTC
The branch main has been updated by joneum:
URL: https://cgit.FreeBSD.org/ports/commit/?id=7197a9cc5dc8ba1059edad13bb199a9919b9c352
commit 7197a9cc5dc8ba1059edad13bb199a9919b9c352
Author: Jochen Neumeister <joneum@FreeBSD.org>
AuthorDate: 2026-10-12 19:44:54 +0000
Commit: Jochen Neumeister <joneum@FreeBSD.org>
CommitDate: 2026-10-12 19:45:26 +0000
databases/mysql267-{server|client}: Add New Port
Welcome MySQL 26.7
MySQL switched to calendar versioning (YY.M) after the 9.7 LTS series,
so 26.7.0 is the first Innovation release after 9.7; there is no 9.8.
What is new in MySQL 26.7:
https://dev.mysql.com/doc/relnotes/mysql/26.7/en/news-26-7-0.html
Compared to mysql97:
- Drop patches for backup_page_tracker.cc and stdx/filesystem.cc,
merged upstream
- Add a missing <time.h> include to mgmapi.h, needed for the new
time_t member of ndb_mgm_cert_table
- Build as C++23 like upstream and drop USE_CXXSTD=c++20
- Drop -malign-double, an i386 workaround while i386 is excluded
- Drop WITH_BOOST, boost is bundled under extra/boost now
- Drop -DWITH_xxx=system already covered by WITH_SYSTEM_LIBS
- Drop the INNOBASE and PERFSCHEMA options, both engines are mandatory,
and PARTITION, which no longer exists
MySQL8.4+ supports only 64-bit platforms!
Sponsored by: Netzkommune GmbH
---
Mk/Uses/mysql.mk | 1 +
Mk/bsd.default-versions.mk | 2 +-
databases/Makefile | 2 +
databases/mysql267-client/Makefile | 49 +++
databases/mysql267-client/pkg-message | 8 +
databases/mysql267-client/pkg-plist | 70 +++++
databases/mysql267-server/Makefile | 157 ++++++++++
databases/mysql267-server/distinfo | 3 +
databases/mysql267-server/files/my.cnf.sample.in | 57 ++++
databases/mysql267-server/files/mysql-server.in | 79 +++++
.../files/mysqlrouter.conf.sample.in | 41 +++
databases/mysql267-server/files/mysqlrouter.in | 93 ++++++
.../mysql267-server/files/patch-CMakeLists.txt | 69 +++++
.../files/patch-client_CMakeLists.txt | 62 ++++
.../files/patch-cmake_install__layout.cmake | 95 ++++++
.../files/patch-cmake_libutils.cmake | 22 ++
.../files/patch-cmake_os_DragonFly.cmake | 27 ++
.../mysql267-server/files/patch-cmake_plugin.cmake | 27 ++
.../mysql267-server/files/patch-cmake_ssl.cmake | 25 ++
...rce__manager_resource__manager__memory__stats.h | 10 +
...sl_time_internal_cctz_src_time__zone__format.cc | 20 ++
.../files/patch-include_my__compare.h | 11 +
.../files/patch-include_my__stacktrace.h | 11 +
.../files/patch-include_my__thread__os__id.h | 15 +
.../mysql267-server/files/patch-include_myisam.h | 11 +
.../files/patch-libmysql_CMakeLists.txt | 64 ++++
.../files/patch-libservices_CMakeLists.txt | 12 +
.../mysql267-server/files/patch-man_CMakeLists.txt | 69 +++++
.../files/patch-mysys_my__default.cc | 62 ++++
.../mysql267-server/files/patch-mysys_my__kdf.cc | 20 ++
...ugin_password__validation_validate__password.cc | 11 +
.../files/patch-plugin_x_CMakeLists.txt | 11 +
...t_authentication_sha256__scramble__generator.cc | 11 +
.../files/patch-plugin_x_configure.cmake | 15 +
...ysql_harness_net__ts_impl_kqueue__io__service.h | 13 +
...arness_include_mysql_harness_net__ts_internet.h | 10 +
...-router_src_harness_src_tls__client__context.cc | 11 +
.../patch-router_src_harness_src_tls__context.cc | 44 +++
...__host__cache_src_rest__host__cache__entries.cc | 12 +
.../files/patch-scripts_CMakeLists.txt | 52 ++++
.../files/patch-scripts_mysqld__safe.sh | 19 ++
.../files/patch-sql_auth_sha2__password__common.cc | 11 +
.../files/patch-sql_auth_sql__authorization.cc | 13 +
.../files/patch-sql_binlog__ostream.cc | 11 +
.../patch-sql_conn__handler_socket__connection.cc | 32 ++
.../files/patch-sql_mdl__context__backup.cc | 36 +++
.../mysql267-server/files/patch-sql_mysqld.cc | 11 +
.../files/patch-sql_rpl__log__encryption.cc | 134 +++++++++
.../patch-sql_server__component_CMakeLists.txt | 12 +
...patch-sql_server__component_mysql__file__imp.cc | 10 +
...l_server__component_mysql__json__encode__imp.cc | 19 ++
.../files/patch-sql_ssl__init__callback.cc | 36 +++
.../mysql267-server/files/patch-sql_sys__vars.cc | 29 ++
.../files/patch-storage_innobase_include_srv0mon.h | 13 +
.../patch-storage_innobase_include_ut0crc32.h | 21 ++
.../files/patch-storage_innobase_ut_crc32.cc | 151 ++++++++++
.../files/patch-storage_myisam_mi__dynrec.cc | 22 ++
.../patch-storage_ndb_include_mgmapi_mgmapi.h | 10 +
.../files/patch-support-files_CMakeLists.txt | 39 +++
.../files/patch-unittest_gunit_stream__cipher-t.cc | 15 +
.../files/patch-utilities_CMakeLists.txt | 68 +++++
.../mysql267-server/files/patch-vio_viossl.cc | 30 ++
.../files/patch-vio_viosslfactories.cc | 46 +++
databases/mysql267-server/files/pkg-message.in | 52 ++++
databases/mysql267-server/pkg-descr | 4 +
databases/mysql267-server/pkg-plist | 327 +++++++++++++++++++++
66 files changed, 2554 insertions(+), 1 deletion(-)
diff --git a/Mk/Uses/mysql.mk b/Mk/Uses/mysql.mk
index 3938cfdfe5be..91533ea9c80f 100644
--- a/Mk/Uses/mysql.mk
+++ b/Mk/Uses/mysql.mk
@@ -62,6 +62,7 @@ DEFAULT_MYSQL_VER?= ${MYSQL_DEFAULT:S/.//}
MYSQL80_LIBVER= 21
MYSQL84_LIBVER= 24
MYSQL97_LIBVER= 24
+MYSQL267_LIBVER= 24
. for v in 1011 114 118 123
MYSQL${v}m_LIBVER= 3
diff --git a/Mk/bsd.default-versions.mk b/Mk/bsd.default-versions.mk
index f2c267f34ffb..2882421244c9 100644
--- a/Mk/bsd.default-versions.mk
+++ b/Mk/bsd.default-versions.mk
@@ -117,7 +117,7 @@ LUAJIT_DEFAULT?= luajit
. endif
# Possible values: 5.10, 5.20, 6.8
MONO_DEFAULT?= 5.20
-# Possible values: 8.0, 8.4, 9.7, 10.11m, 11.4m, 11.8m
+# Possible values: 8.0, 8.4, 9.7, 26.7, 10.11m, 11.4m, 11.8m
MYSQL_DEFAULT?= 8.4
# Possible values: ninja, samurai
NINJA_DEFAULT?= ninja
diff --git a/databases/Makefile b/databases/Makefile
index 791404eed182..93f860a314d2 100644
--- a/databases/Makefile
+++ b/databases/Makefile
@@ -206,6 +206,8 @@
SUBDIR += mysql-connector-odbc
SUBDIR += mysql-shell
SUBDIR += mysql2pgsql
+ SUBDIR += mysql267-client
+ SUBDIR += mysql267-server
SUBDIR += mysql80-client
SUBDIR += mysql80-server
SUBDIR += mysql84-client
diff --git a/databases/mysql267-client/Makefile b/databases/mysql267-client/Makefile
new file mode 100644
index 000000000000..b2bc84f52404
--- /dev/null
+++ b/databases/mysql267-client/Makefile
@@ -0,0 +1,49 @@
+PORTNAME= mysql
+PKGNAMESUFFIX= 267-client
+
+COMMENT= Multithreaded SQL database (client)
+
+LICENSE+= LGPL21
+
+# Slave port of databases/mysql267-server; see the note there on repology
+# reporting this series as outdated.
+
+# MySQL8.2+ supports only 64-bit platforms
+NOT_FOR_ARCHS= armv6 armv7 i386 powerpc
+
+MASTERDIR= ${.CURDIR}/../mysql267-server
+
+PKGMESSAGE= ${.CURDIR}/pkg-message
+PATCHDIR= ${MASTERDIR}/files
+PLIST= ${.CURDIR}/pkg-plist
+
+CONFLICTS_INSTALL= mysql*-client \
+ mariadb*-client \
+ percona*-client
+
+CMAKE_ARGS+= -DWITHOUT_SERVER=1 -DINSTALL_SUPPORTFILESDIR=0
+
+CPE_PRODUCT= mysql
+
+USE_LDCONFIG+= ${PREFIX}/lib/mysql
+
+CLIENT_ONLY= yes
+
+OPTIONS_GROUP+= PLUGINS
+PLUGINS_DESC= Default Client Plugins
+OPTIONS_GROUP_PLUGINS= SASLCLIENT
+SASLCLIENT_DESC= SASL client plugin module
+SASLCLIENT_CMAKE_BOOL= WITH_AUTHENTICATION_LDAP
+SASLCLIENT_LIB_DEPENDS= libsasl2.so:security/cyrus-sasl2
+SASLCLIENT_USES= ldap
+
+OPTIONS_DEFAULT+= SASLCLIENT
+OPTIONS_SUB= yes
+
+post-install:
+ @${RM} -r ${STAGEDIR}${PREFIX}/lib/mysql/private
+ @${LN} -s libmysqlclient.a ${STAGEDIR}${PREFIX}/lib/mysql/libmysqlclient_r.a
+ @${LN} -s libmysqlclient.so ${STAGEDIR}${PREFIX}/lib/mysql/libmysqlclient_r.so
+ @${LN} -s libmysqlclient.so.24 ${STAGEDIR}${PREFIX}/lib/mysql/libmysqlclient_r.so.24
+
+.include "${MASTERDIR}/Makefile"
diff --git a/databases/mysql267-client/pkg-message b/databases/mysql267-client/pkg-message
new file mode 100644
index 000000000000..f2079381b504
--- /dev/null
+++ b/databases/mysql267-client/pkg-message
@@ -0,0 +1,8 @@
+[
+{ type: install
+ message: <<EOM
+This is the mysql CLIENT without the server.
+for complete server and client, please install databases/mysql267-server
+EOM
+}
+]
diff --git a/databases/mysql267-client/pkg-plist b/databases/mysql267-client/pkg-plist
new file mode 100644
index 000000000000..6f3082f14b1b
--- /dev/null
+++ b/databases/mysql267-client/pkg-plist
@@ -0,0 +1,70 @@
+bin/comp_err
+bin/my_print_defaults
+bin/mysql
+bin/mysql_config
+bin/mysql_config_editor
+bin/mysql_migrate_keyring
+bin/mysqladmin
+bin/mysqlbinlog
+bin/mysqlcheck
+bin/mysqldump
+bin/mysqlimport
+bin/mysqlshow
+bin/mysqlslap
+bin/perror
+include/mysql/errmsg.h
+include/mysql/field_types.h
+include/mysql/my_command.h
+include/mysql/my_compress.h
+include/mysql/my_list.h
+include/mysql/mysql.h
+include/mysql/mysql/client_plugin.h
+include/mysql/mysql/plugin_auth_common.h
+include/mysql/mysql/udf_registration_types.h
+include/mysql/mysql_com.h
+include/mysql/mysql_time.h
+include/mysql/mysql_version.h
+include/mysql/mysqld_error.h
+lib/mysql/libmysqlclient.a
+lib/mysql/libmysqlclient.so
+lib/mysql/libmysqlclient.so.24
+lib/mysql/libmysqlclient_r.a
+lib/mysql/libmysqlclient_r.so
+lib/mysql/libmysqlclient_r.so.24
+%%SASLCLIENT%%lib/mysql/plugin/authentication_ldap_sasl_client.so
+%%SASLCLIENT%%lib/mysql/plugin/authentication_oci_client.so
+%%SASLCLIENT%%lib/mysql/plugin/authentication_openid_connect_client.so
+%%SASLCLIENT%%lib/mysql/plugin/authentication_webauthn_client.so
+%%SASLCLIENT%%lib/mysql/plugin/mysql_native_password.so
+libdata/pkgconfig/mysqlclient.pc
+share/aclocal/mysql.m4
+share/man/man1/comp_err.1.gz
+@comment share/man/man1/ibd2sdi.1.gz
+@comment share/man/man1/innochecksum.1.gz
+@comment share/man/man1/my_print_defaults.1.gz
+@comment share/man/man1/myisam_ftdump.1.gz
+@comment share/man/man1/myisamchk.1.gz
+@comment share/man/man1/myisamlog.1.gz
+@comment share/man/man1/myisampack.1.gz
+share/man/man1/mysql.1.gz
+@comment share/man/man1/mysql.server.1.gz
+share/man/man1/mysql_config.1.gz
+share/man/man1/mysql_config_editor.1.gz
+@comment share/man/man1/mysql_secure_installation.1.gz
+@comment share/man/man1/mysql_tzinfo_to_sql.1.gz
+share/man/man1/mysqladmin.1.gz
+share/man/man1/mysqlbinlog.1.gz
+share/man/man1/mysqlcheck.1.gz
+@comment share/man/man1/mysqld_multi.1.gz
+@comment share/man/man1/mysqld_safe.1.gz
+share/man/man1/mysqldump.1.gz
+@comment share/man/man1/mysqldumpslow.1.gz
+share/man/man1/mysqlimport.1.gz
+share/man/man1/mysqlman.1.gz
+@comment share/man/man1/mysqlrouter.1.gz
+@comment share/man/man1/mysqlrouter_passwd.1.gz
+@comment share/man/man1/mysqlrouter_plugin_info.1.gz
+share/man/man1/mysqlshow.1.gz
+share/man/man1/mysqlslap.1.gz
+share/man/man1/perror.1.gz
+@comment share/man/man8/mysqld.8.gz
diff --git a/databases/mysql267-server/Makefile b/databases/mysql267-server/Makefile
new file mode 100644
index 000000000000..e81f58a451cb
--- /dev/null
+++ b/databases/mysql267-server/Makefile
@@ -0,0 +1,157 @@
+PORTNAME?= mysql
+PORTVERSION= 26.7.0
+CATEGORIES= databases
+MASTER_SITES= MYSQL/MySQL-26.7
+PKGNAMESUFFIX?= 267-server
+
+MAINTAINER= joneum@FreeBSD.org
+COMMENT?= Multithreaded SQL database (server)
+WWW= https://www.mysql.com/
+
+LICENSE= GPLv2
+
+# Tracks one MySQL release series; the others are separate mysql*-server ports.
+# repology merges all series into one project and measures against the newest
+# train upstream ships, so its outdated report is an artifact, not an update.
+
+# MySQL8.2+ supports only 64-bit platforms
+NOT_FOR_ARCHS= armv6 armv7 i386 powerpc
+
+USES= bison:build cmake:noninja cpe groff:run libedit localbase \
+ ncurses perl5 pkgconfig shebangfix ssl compiler:c++23-lang
+
+WRKSRC= ${WRKDIR}/${PORTNAME}-${PORTVERSION}${DISTVERSIONSUFFIX}
+
+SLAVEDIRS= databases/mysql267-client
+
+CPE_PRODUCT?= mysql_server
+CPE_VENDOR= oracle
+
+USE_PERL5= run
+
+MY_DBDIR= /var/db/mysql
+MY_SECDIR= /var/db/mysql_secure
+MY_TMPDIR= /var/db/mysql_tmpdir
+
+.if defined(CLIENT_ONLY)
+BUILD_DEPENDS+= curl>0:ftp/curl \
+ icu>0:devel/icu \
+ liblz4>0:archivers/liblz4
+LIB_DEPENDS+= libfido2.so:security/libfido2
+.else
+LIB_DEPENDS+= libcurl.so:ftp/curl \
+ libicutu.so:devel/icu \
+ liblz4.so:archivers/liblz4
+.endif
+
+CMAKE_BUILD_TYPE= Release
+CFLAGS+= -fPIC
+CFLAGS_aarch64?= -march=armv8-a+crc+crypto
+
+CMAKE_ARGS+= -DINSTALL_LAYOUT=FREEBSD \
+ -DINSTALL_LDCONFIGDIR="${LOCALBASE}/libdata/ldconfig" \
+ -DINSTALL_PKGCONFIGDIR="${LOCALBASE}/libdata/pkgconfig" \
+ -DINSTALL_DOCDIR="share/doc/mysql" \
+ -DINSTALL_DOCREADMEDIR="share/doc/mysql" \
+ -DINSTALL_INCLUDEDIR="include/mysql" \
+ -DINSTALL_INFODIR="${INFO_PATH}" \
+ -DINSTALL_LIBDIR="lib/mysql" \
+ -DINSTALL_PRIV_LIBDIR="lib/mysql/private" \
+ -DINSTALL_MANDIR="share/man" \
+ -DINSTALL_MYSQLDATADIR="${MY_DBDIR}" \
+ -DINSTALL_MYSQLKEYRINGDIR="etc/mysql/keyring" \
+ -DINSTALL_MYSQLSHAREDIR="share/mysql" \
+ -DINSTALL_MYSQLTESTDIR="" \
+ -DINSTALL_PLUGINDIR="lib/mysql/plugin" \
+ -DINSTALL_SBINDIR="libexec" \
+ -DINSTALL_SCRIPTDIR="bin" \
+ -DINSTALL_SECURE_FILE_PRIVDIR="${MY_SECDIR}" \
+ -DINSTALL_SHAREDIR="share" \
+ -DINSTALL_SUPPORTFILESDIR="share/mysql" \
+ -DWITH_SYSTEM_LIBS=1 \
+ -DWITH_ZSTD=bundled \
+ -DWITH_PROTOBUF=bundled
+
+SHEBANG_FILES= scripts/*.pl* scripts/*.sh
+
+.ifdef USE_MYSQL
+IGNORE= you have `USE_MYSQL' variable defined either in environment or in make(1) arguments, please undefine and try again
+.endif
+
+SUB_LIST= MY_DBDIR=${MY_DBDIR} \
+ MY_SECDIR=${MY_SECDIR} \
+ MY_TMPDIR=${MY_TMPDIR}
+
+PLIST_SUB= MY_DBDIR=${MY_DBDIR} \
+ MY_SECDIR=${MY_SECDIR} \
+ MY_TMPDIR=${MY_TMPDIR}
+
+# MySQL-Server part
+.if !defined(CLIENT_ONLY)
+USES+= mysql:267
+
+CONFLICTS_INSTALL= mysql*-server \
+ mysqlwsrep*-server \
+ mariadb*-server \
+ percona*-server
+
+USE_RC_SUBR= mysql-server mysqlrouter
+
+SUB_FILES= my.cnf.sample mysqlrouter.conf.sample pkg-message
+
+USERS= mysql mysqlrouter
+GROUPS= mysql mysqlrouter
+
+USE_LDCONFIG+= ${PREFIX}/lib/mysql/plugin
+
+CMAKE_ARGS+= -DWITHOUT_CLIENTLIBS="ON"
+CMAKE_ARGS+= -DWITH_UNIT_TESTS="OFF"
+
+OPTIONS_GROUP= STORAGE
+OPTIONS_GROUP_STORAGE= ARCHIVE BLACKHOLE EXAMPLE FEDERATED
+OPTIONS_SUB= YES
+STORAGE_DESC= Permissible "Storage Engines" (to compile statically into the server)
+ARCHIVE_DESC= Compile "Archive Storage" statically in server
+BLACKHOLE_DESC= Compile "Blackhole Storage" statically in server
+EXAMPLE_DESC= Compile "Example Storage" statically in server
+FEDERATED_DESC= Compile "Federated Storage" statically in server
+
+ARCHIVE_CMAKE_ON= -DWITH_ARCHIVE_STORAGE_ENGINE=1
+BLACKHOLE_CMAKE_ON= -DWITH_BLACKHOLE_STORAGE_ENGINE=1
+EXAMPLE_CMAKE_ON= -DWITH_EXAMPLE_STORAGE_ENGINE=1
+FEDERATED_CMAKE_ON= -DWITH_FEDERATED_STORAGE_ENGINE=1
+
+OPTIONS_GROUP+= FEATURES
+OPTIONS_GROUP_FEATURES= PERFSCHM
+FEATURES_DESC= Default features knobs
+PERFSCHM_DESC= Enable "Performance Schema" by default (High RAM usage)
+OPTIONS_DEFAULT+= PERFSCHM
+
+PERFSCHM_SUB_LIST+= PERFSCHEMRC=""
+PERFSCHM_SUB_LIST_OFF+= PERFSCHEMRC="--skip-performance-schema"
+FEDERATED_SUB_LIST+= FEDER="--federated"
+FEDERATED_SUB_LIST_OFF+= FEDER=""
+.endif
+
+.include <bsd.port.options.mk>
+
+.include <bsd.port.pre.mk>
+
+post-extract:
+ @${RM} -rv ${WRKSRC}/sql/sql_hints.yy.cc ${WRKSRC}/sql/sql_hints.yy.h
+
+.if !defined(CLIENT_ONLY)
+post-install:
+ ${MKDIR} ${STAGEDIR}${ETCDIR}
+ ${INSTALL_DATA} ${WRKDIR}/my.cnf.sample ${STAGEDIR}${ETCDIR}/my.cnf.sample
+ ${MKDIR} ${STAGEDIR}${PREFIX}/etc/mysqlrouter
+ ${INSTALL_DATA} ${WRKDIR}/mysqlrouter.conf.sample \
+ ${STAGEDIR}${PREFIX}/etc/mysqlrouter/mysqlrouter.conf.sample
+ ${MKDIR} ${STAGEDIR}${ETCDIR}/keyring
+ ${MKDIR} ${STAGEDIR}${MY_SECDIR}
+ ${MKDIR} ${STAGEDIR}${MY_TMPDIR}
+ ${MKDIR} ${STAGEDIR}${DOCSDIR}
+ ${MV} ${STAGEDIR}${PREFIX}/LICENSE.router ${STAGEDIR}${PREFIX}/README.router ${STAGEDIR}${DOCSDIR}
+.endif
+
+.include <bsd.port.post.mk>
diff --git a/databases/mysql267-server/distinfo b/databases/mysql267-server/distinfo
new file mode 100644
index 000000000000..fc57345da83a
--- /dev/null
+++ b/databases/mysql267-server/distinfo
@@ -0,0 +1,3 @@
+TIMESTAMP = 1791829936
+SHA256 (mysql-26.7.0.tar.gz) = 95e949183b94bbe39e70c6355e6c90d2a640a62ede996ca5f7a6a3e0827a3260
+SIZE (mysql-26.7.0.tar.gz) = 459475424
diff --git a/databases/mysql267-server/files/my.cnf.sample.in b/databases/mysql267-server/files/my.cnf.sample.in
new file mode 100644
index 000000000000..3d1264c1bd61
--- /dev/null
+++ b/databases/mysql267-server/files/my.cnf.sample.in
@@ -0,0 +1,57 @@
+[client]
+port = 3306
+socket = /tmp/mysql.sock
+
+[mysql]
+prompt = \u@\h [\d]>\_
+no_auto_rehash
+
+[mysqld]
+user = mysql
+port = 3306
+socket = /tmp/mysql.sock
+bind-address = 127.0.0.1
+basedir = %%PREFIX%%
+datadir = %%MY_DBDIR%%
+tmpdir = %%MY_TMPDIR%%
+replica-load-tmpdir = %%MY_TMPDIR%%
+secure-file-priv = %%MY_SECDIR%%
+log-bin = mysql-bin
+log-output = TABLE
+relay-log-recovery = 1
+slow-query-log = 1
+server-id = 1
+sync_binlog = 1
+sync_relay_log = 1
+binlog_cache_size = 16M
+binlog_expire_logs_seconds = 2592000
+default_password_lifetime = 0
+enforce-gtid-consistency = 1
+gtid-mode = ON
+safe-user-create = 1
+lower_case_table_names = 1
+explicit-defaults-for-timestamp = 1
+myisam-recover-options = BACKUP,FORCE
+open_files_limit = 32768
+table_open_cache = 16384
+table_definition_cache = 8192
+net_retry_count = 16384
+key_buffer_size = 256M
+max_allowed_packet = 64M
+long_query_time = 0.5
+innodb_buffer_pool_size = 1G
+innodb_data_home_dir = %%MY_DBDIR%%
+innodb_log_group_home_dir = %%MY_DBDIR%%
+innodb_data_file_path = ibdata1:128M:autoextend
+innodb_temp_data_file_path = ibtmp1:128M:autoextend
+innodb_flush_method = O_DIRECT
+innodb_redo_log_capacity = 512M
+innodb_log_buffer_size = 16M
+innodb_write_io_threads = 8
+innodb_read_io_threads = 8
+innodb_autoinc_lock_mode = 2
+
+[mysqldump]
+max_allowed_packet = 256M
+quote_names
+quick
diff --git a/databases/mysql267-server/files/mysql-server.in b/databases/mysql267-server/files/mysql-server.in
new file mode 100644
index 000000000000..73e5bcf282ce
--- /dev/null
+++ b/databases/mysql267-server/files/mysql-server.in
@@ -0,0 +1,79 @@
+#!/bin/sh
+
+# PROVIDE: mysql
+# REQUIRE: LOGIN
+# KEYWORD: shutdown
+
+#
+# Add the following line to /etc/rc.conf to enable mysql:
+# mysql_enable (bool): Set to "NO" by default.
+# Set it to "YES" to enable MySQL.
+# mysql_dbdir (str): Default to "%%MY_DBDIR%%"
+# Base database directory.
+# mysql_confdir (str): Default to "%%ETCDIR%%"
+# Base configuration directory.
+# mysql_optfile (str): Server-specific option file.
+# Set it in the rc.conf or default behaviour of
+# `mysqld_safe` itself, will be picking
+# ${mysql_confdir}/my.cnf if it exists.
+# mysql_pidfile (str): Custom PID file path and name.
+# Default to "${mysql_dbdir}/${hostname}.pid".
+# mysql_args (str): Custom additional arguments to be passed
+# to mysqld_safe (default empty).
+#
+
+. /etc/rc.subr
+
+name="mysql"
+rcvar=mysql_enable
+
+load_rc_config $name
+
+: ${mysql_enable="NO"}
+: ${mysql_svcj_options="net_basic"}
+: ${mysql_dbdir="%%MY_DBDIR%%"}
+: ${mysql_confdir="%%ETCDIR%%"}
+if [ -f "${mysql_confdir}/my.cnf" ]; then
+: ${mysql_optfile="${mysql_confdir}/my.cnf"}
+elif [ -f "${mysql_dbdir}/my.cnf" ]; then
+: ${mysql_optfile="${mysql_dbdir}/my.cnf"}
+fi
+if [ ! -z "${mysql_optfile}" ]; then
+mysql_extra="--defaults-extra-file=${mysql_optfile}"
+fi
+
+mysql_user="mysql"
+: ${hostname:=`/bin/hostname`}
+pidfile=${mysql_pidfile:-"${mysql_dbdir}/${hostname}.pid"}
+command="/usr/sbin/daemon"
+command_args="-c -f %%PREFIX%%/bin/mysqld_safe ${mysql_extra} --basedir=%%PREFIX%% --datadir=${mysql_dbdir} --pid-file=${pidfile} --user=${mysql_user} ${mysql_args} %%FEDER%% %%PERFSCHEMRC%%"
+procname="%%PREFIX%%/libexec/mysqld"
+start_precmd="${name}_prestart"
+start_postcmd="${name}_poststart"
+mysqld_init="${procname}"
+mysqld_init_args="${mysql_extra} --initialize-insecure --basedir=%%PREFIX%% --datadir=${mysql_dbdir} --user=${mysql_user}"
+
+mysql_create_auth_tables()
+{
+ eval $mysqld_init $mysqld_init_args >/dev/null 2>/dev/null
+}
+
+mysql_prestart()
+{
+ if [ ! -d "${mysql_dbdir}/mysql/." ]; then
+ mysql_create_auth_tables || return 1
+ fi
+ return 0
+}
+
+mysql_poststart()
+{
+ local timeout=15
+ while [ ! -f "${pidfile}" -a ${timeout} -gt 0 ]; do
+ timeout=$(( timeout - 1 ))
+ sleep 1
+ done
+ return 0
+}
+
+run_rc_command "$1"
diff --git a/databases/mysql267-server/files/mysqlrouter.conf.sample.in b/databases/mysql267-server/files/mysqlrouter.conf.sample.in
new file mode 100644
index 000000000000..23b9de4c93ab
--- /dev/null
+++ b/databases/mysql267-server/files/mysqlrouter.conf.sample.in
@@ -0,0 +1,41 @@
+# MySQL Router default configuration for FreeBSD.
+#
+# This template starts the router, but it does not route anything yet. Either
+# add a [routing] or [metadata_cache] section by hand, or let
+# "mysqlrouter --bootstrap" generate a complete configuration. A commented
+# upstream example is installed as
+# %%DATADIR%%router/docs/sample_mysqlrouter.conf
+#
+# The paths below have to stay in sync with these two files:
+# %%PREFIX%%/etc/rc.d/mysqlrouter creates the directories
+# %%PREFIX%%/etc/logrotate.d/mysqlrouter rotates the log, sends SIGHUP
+#
+# Do NOT set "pid_file" here. The PID file is written by daemon(8) through the
+# rc script. With an own pid_file entry mysqlrouter aborts the next start with
+# "PID file ... found. Already running?" after an unclean shutdown.
+#
+# Do NOT set "user" here. The rc script drops privileges with "daemon -u"
+# before mysqlrouter is executed.
+
+[DEFAULT]
+logging_folder = /var/log/mysqlrouter
+runtime_folder = /var/run/mysqlrouter
+data_folder = /var/db/mysqlrouter
+plugin_folder = %%PREFIX%%/lib/mysql/mysqlrouter
+config_folder = %%PREFIX%%/etc/mysqlrouter
+
+[logger]
+level = INFO
+filename = mysqlrouter.log
+
+# Without a plugin that provides a service mysqlrouter exits immediately.
+# keepalive keeps it alive until real [routing] or [metadata_cache] sections
+# are configured, afterwards it can be removed.
+[keepalive]
+interval = 60
+
+#[routing:example]
+#bind_address = 127.0.0.1
+#bind_port = 6446
+#destinations = 192.0.2.1:3306,192.0.2.2:3306
+#routing_strategy = first-available
diff --git a/databases/mysql267-server/files/mysqlrouter.in b/databases/mysql267-server/files/mysqlrouter.in
new file mode 100644
index 000000000000..29de9c0bc792
--- /dev/null
+++ b/databases/mysql267-server/files/mysqlrouter.in
@@ -0,0 +1,93 @@
+#!/bin/sh
+
+# PROVIDE: mysqlrouter
+# REQUIRE: LOGIN
+# KEYWORD: shutdown
+
+#
+# Add the following lines to /etc/rc.conf to enable mysqlrouter:
+#
+# mysqlrouter_enable (bool): Set to "NO" by default.
+# Set it to "YES" to enable mysqlrouter.
+# mysqlrouter_config (str): Configuration file.
+# Default "%%PREFIX%%/etc/mysqlrouter/mysqlrouter.conf".
+# mysqlrouter_user (str): User to run mysqlrouter as, handled by rc.subr.
+# Default "mysqlrouter".
+# mysqlrouter_group (str): Group of the runtime, log and data directory.
+# Default "mysqlrouter".
+# mysqlrouter_login_class (str): Login class, see rc.subr(8) and
+# login.conf(5). Raise openfiles there when the
+# router has to serve many connections, upstream
+# uses 10000. Default "daemon".
+# mysqlrouter_rundir (str): Runtime directory. Must match "runtime_folder"
+# in the configuration file and the path used by
+# %%PREFIX%%/etc/logrotate.d/mysqlrouter.
+# Default "/var/run/mysqlrouter".
+# mysqlrouter_logdir (str): Log directory. Must match "logging_folder".
+# Default "/var/log/mysqlrouter".
+# mysqlrouter_datadir (str): Data directory, holds the keyring and the
+# dynamic state. Must match "data_folder".
+# Default "/var/db/mysqlrouter".
+# mysqlrouter_args (str): Custom additional arguments (default empty).
+#
+# mysqlrouter does not detach itself, so it is run under daemon(8). The PID
+# file is written by daemon(8), not by mysqlrouter. Do not add a "pid_file"
+# entry to the configuration file, mysqlrouter would then refuse to start
+# with "PID file ... found. Already running?".
+#
+
+. /etc/rc.subr
+
+name="mysqlrouter"
+rcvar=mysqlrouter_enable
+
+load_rc_config $name
+
+: ${mysqlrouter_enable:="NO"}
+: ${mysqlrouter_config:="%%PREFIX%%/etc/mysqlrouter/mysqlrouter.conf"}
+: ${mysqlrouter_user:="mysqlrouter"}
+: ${mysqlrouter_group:="mysqlrouter"}
+: ${mysqlrouter_rundir:="/var/run/mysqlrouter"}
+: ${mysqlrouter_logdir:="/var/log/mysqlrouter"}
+: ${mysqlrouter_datadir:="/var/db/mysqlrouter"}
+: ${mysqlrouter_args:=""}
+
+pidfile="${mysqlrouter_rundir}/${name}.pid"
+procname="%%PREFIX%%/bin/mysqlrouter"
+required_files="${mysqlrouter_config}"
+
+command="/usr/sbin/daemon"
+command_args="-c -f -S -T ${name} -p ${pidfile} \
+ ${procname} --config ${mysqlrouter_config} ${mysqlrouter_args}"
+
+extra_commands="reload"
+sig_reload="HUP"
+
+start_precmd="${name}_precmd"
+
+mysqlrouter_precmd()
+{
+ # /var/run is cleared on boot and mysqlrouter cannot create the
+ # directory itself: it drops privileges before the runtime directory
+ # is used. daemon(8) needs it to exist before it opens the PID file,
+ # and rc.subr runs the whole command as ${mysqlrouter_user}, so the
+ # directory has to belong to that account. A unix socket configured
+ # in a [routing] section is created here as well.
+ install -d -o "${mysqlrouter_user}" -g "${mysqlrouter_group}" -m 0750 \
+ "${mysqlrouter_rundir}" || return 1
+
+ # Only create these, never touch an existing directory: an
+ # administrator may already run mysqlrouter under a different account.
+ if [ ! -d "${mysqlrouter_logdir}" ]; then
+ install -d -o "${mysqlrouter_user}" -g "${mysqlrouter_group}" \
+ -m 0750 "${mysqlrouter_logdir}" || return 1
+ fi
+ if [ ! -d "${mysqlrouter_datadir}" ]; then
+ install -d -o "${mysqlrouter_user}" -g "${mysqlrouter_group}" \
+ -m 0750 "${mysqlrouter_datadir}" || return 1
+ fi
+
+ return 0
+}
+
+run_rc_command "$1"
diff --git a/databases/mysql267-server/files/patch-CMakeLists.txt b/databases/mysql267-server/files/patch-CMakeLists.txt
new file mode 100644
index 000000000000..53ead510856b
--- /dev/null
+++ b/databases/mysql267-server/files/patch-CMakeLists.txt
@@ -0,0 +1,69 @@
+--- CMakeLists.txt.orig 2026-07-10 11:18:36 UTC
++++ CMakeLists.txt
+@@ -1986,7 +1986,7 @@ IF(WITH_AUTHENTICATION_LDAP)
+ ENDIF()
+
+ IF(WITH_AUTHENTICATION_LDAP)
+- IF(LINUX AND KNOWN_CUSTOM_LIBRARIES)
++ IF(LINUX OR FREEBSD AND KNOWN_CUSTOM_LIBRARIES)
+ # LDAP / SASL / KERBEROS / SSL must all be "system" or "custom", not a mix.
+ IF(WITH_LDAP STREQUAL "system" OR
+ WITH_SASL STREQUAL "system" OR
+@@ -2037,6 +2037,7 @@ ENDIF()
+ ENDIF()
+ ENDIF()
+
++IF(NOT WITHOUT_TOOLS)
+ # Add system/bundled editline.
+ MYSQL_CHECK_EDITLINE()
+ SET(EDITLINE_WARN_GIVEN)
+@@ -2047,6 +2048,7 @@ ENDIF()
+ "You can use -DWITH_EDITLINE=bundled instead."
+ )
+ ENDIF()
++ENDIF(NOT WITHOUT_TOOLS)
+
+ # Add lz4 library
+ MYSQL_CHECK_LZ4()
+@@ -2359,7 +2361,9 @@ ADD_DEPENDENCIES(clang_tidy_prerequisites GenError)
+ ADD_DEPENDENCIES(clang_tidy_prerequisites protobuf_generated_all)
+ ADD_DEPENDENCIES(clang_tidy_prerequisites GenError)
+
+-ADD_SUBDIRECTORY(include)
++IF(NOT WITHOUT_CLIENTLIBS)
++ ADD_SUBDIRECTORY(include)
++ENDIF(NOT WITHOUT_CLIENTLIBS)
+ ADD_SUBDIRECTORY(strings)
+ ADD_SUBDIRECTORY(extra/unordered_dense)
+ ADD_SUBDIRECTORY(extra/xxhash)
+@@ -2420,12 +2424,15 @@ ENDIF()
+ ADD_SUBDIRECTORY(unittest/mytap/t)
+ ENDIF()
+
+-ADD_SUBDIRECTORY(client)
++IF(NOT WITHOUT_TOOLS)
++ ADD_SUBDIRECTORY(client)
++ENDIF(NOT WITHOUT_TOOLS)
++
+ ADD_SUBDIRECTORY(utilities)
+-ADD_SUBDIRECTORY(share)
+ ADD_SUBDIRECTORY(libservices)
+
+ IF(NOT WITHOUT_SERVER)
++ ADD_SUBDIRECTORY(share)
+ ADD_SUBDIRECTORY(testclients)
+ ADD_SUBDIRECTORY(sql)
+ ENDIF()
+@@ -2505,11 +2512,11 @@ ADD_SUBDIRECTORY(scripts)
+ # scripts/mysql_config depends on client and server targets loaded above.
+ # It is referenced by some of the directories below, so we insert it here.
+ ADD_SUBDIRECTORY(scripts)
++ADD_SUBDIRECTORY(support-files)
+
+ IF(NOT WITHOUT_SERVER)
+ ADD_SUBDIRECTORY(mysql-test)
+ ADD_SUBDIRECTORY(mysql-test/lib/My/SafeProcess)
+- ADD_SUBDIRECTORY(support-files)
+ IF(WITH_INTERNAL)
+ ADD_SUBDIRECTORY(internal)
+ ENDIF()
diff --git a/databases/mysql267-server/files/patch-client_CMakeLists.txt b/databases/mysql267-server/files/patch-client_CMakeLists.txt
new file mode 100644
index 000000000000..c062af2aa2e8
--- /dev/null
+++ b/databases/mysql267-server/files/patch-client_CMakeLists.txt
@@ -0,0 +1,62 @@
+--- client/CMakeLists.txt.orig 2026-07-10 11:18:36 UTC
++++ client/CMakeLists.txt
+@@ -26,9 +26,12 @@ DISABLE_MISSING_PROFILE_WARNING()
+ # We are not interesting in profiling clients.
+ DISABLE_MISSING_PROFILE_WARNING()
+
++IF(WITHOUT_SERVER)
+ ## Subdirectory for mysql_migrate_keyring code.
+ ADD_SUBDIRECTORY(migrate_keyring)
++ENDIF()
+
++IF(WITHOUT_SERVER)
+ MYSQL_ADD_EXECUTABLE(mysql
+ ${CMAKE_SOURCE_DIR}/sql-common/net_ns.cc
+ completion_hash.cc
+@@ -42,7 +45,9 @@ MYSQL_ADD_EXECUTABLE(mysql
+ ${CMAKE_SOURCE_DIR}/sql-common/sql_string.cc
+ LINK_LIBRARIES mysqlclient ${EDITLINE_LIBRARY}
+ )
++ENDIF()
+
++IF(NOT_WITHOUT_SERVER)
+ MYSQL_ADD_EXECUTABLE(mysqltest
+ mysqltest.cc
+ mysqltest/error_names.cc
+@@ -59,9 +64,11 @@ MYSQL_ADD_EXECUTABLE(mysqltest
+ ENABLE_EXPORTS
+ LINK_LIBRARIES mysqlclient
+ )
++ENDIF()
+
+ DOWNGRADE_STRINGOP_WARNINGS(mysqltest)
+
++IF(WITHOUT_SERVER)
+ MYSQL_ADD_EXECUTABLE(mysqlcheck
+ check/mysqlcheck.cc
+ check/mysqlcheck_core.cc
+@@ -302,7 +309,9 @@ ENDIF()
+ TARGET_COMPILE_DEFINITIONS(mysqlbinlog PRIVATE DISABLE_PSI_MUTEX)
+ TARGET_INCLUDE_DIRECTORIES(mysqlbinlog PRIVATE ${CMAKE_SOURCE_DIR}/sql)
+ ENDIF()
++ENDIF()
+
++IF(WITHOUT_SERVER)
+ MYSQL_ADD_EXECUTABLE(mysqladmin
+ mysqladmin.cc
+ multi_factor_passwordopt-vars.cc
+@@ -317,10 +326,14 @@ MYSQL_ADD_EXECUTABLE(mysql_config_editor
+ mysql_config_editor.cc
+ LINK_LIBRARIES mysqlclient
+ )
++ENDIF()
++
++IF(NOT_WITHOUT_SERVER)
+ MYSQL_ADD_EXECUTABLE(mysql_secure_installation
+ mysql_secure_installation.cc
+ LINK_LIBRARIES mysqlclient
+ )
++ENDIF()
+
+ # "WIN32" also covers 64 bit. "echo" is used in some files below "mysql-test/".
+ IF(WIN32)
diff --git a/databases/mysql267-server/files/patch-cmake_install__layout.cmake b/databases/mysql267-server/files/patch-cmake_install__layout.cmake
new file mode 100644
index 000000000000..78d8757b800c
--- /dev/null
+++ b/databases/mysql267-server/files/patch-cmake_install__layout.cmake
@@ -0,0 +1,95 @@
+--- cmake/install_layout.cmake.orig 2026-07-10 11:18:36 UTC
++++ cmake/install_layout.cmake
+@@ -42,6 +42,10 @@
+ # Build with prefix=/usr/local/mysql, create tarball with install prefix="."
+ # and relative links.
+ #
++# FREEBSD
++# Build with prefix=/usr/local, create tarball with install prefix="."
++# and relative links.
++#
+ # To force a directory layout, use -DINSTALL_LAYOUT=<layout>.
+ #
+ # The default is STANDALONE.
+@@ -81,7 +85,7 @@ SET(INSTALL_LAYOUT "${DEFAULT_INSTALL_LAYOUT}"
+ ENDIF()
+
+ SET(INSTALL_LAYOUT "${DEFAULT_INSTALL_LAYOUT}"
+- CACHE STRING "Installation directory layout. Options are: TARGZ (as in tar.gz installer), STANDALONE, RPM, DEB, SVR4"
++ CACHE STRING "Installation directory layout. Options are: TARGZ (as in tar.gz installer), STANDALONE, FREEBSD, RPM, DEB, SVR4"
+ )
+
+ IF(UNIX)
+@@ -99,7 +103,7 @@ IF(UNIX)
+ CACHE PATH "install prefix" FORCE)
+ ENDIF()
+ SET(VALID_INSTALL_LAYOUTS
+- "RPM" "DEB" "SVR4" "TARGZ" "STANDALONE")
++ "RPM" "DEB" "SVR4" "TARGZ" "FREEBSD" "STANDALONE")
+ LIST(FIND VALID_INSTALL_LAYOUTS "${INSTALL_LAYOUT}" ind)
+ IF(ind EQUAL -1)
+ MESSAGE(FATAL_ERROR "Invalid INSTALL_LAYOUT parameter:${INSTALL_LAYOUT}."
+@@ -168,6 +172,32 @@ SET(INSTALL_SECURE_FILE_PRIVDIR_STANDALONE ${secure_fi
+ SET(INSTALL_SECURE_FILE_PRIVDIR_STANDALONE ${secure_file_priv_path})
+
+ #
++# FREEBSD layout
++#
++SET(INSTALL_BINDIR_FREEBSD "bin")
++SET(INSTALL_SBINDIR_FREEBSD "bin")
++#
++SET(INSTALL_LIBDIR_FREEBSD "lib")
++SET(INSTALL_PRIV_LIBDIR_FREEBSD "lib/private")
++SET(INSTALL_PLUGINDIR_FREEBSD "lib/plugin")
++#
++SET(INSTALL_INCLUDEDIR_FREEBSD "include")
++#
++SET(INSTALL_DOCDIR_FREEBSD "docs")
++SET(INSTALL_DOCREADMEDIR_FREEBSD ".")
++SET(INSTALL_MANDIR_FREEBSD "man")
++SET(INSTALL_INFODIR_FREEBSD "docs")
++#
++SET(INSTALL_SHAREDIR_FREEBSD "share")
++SET(INSTALL_MYSQLSHAREDIR_FREEBSD "share")
++SET(INSTALL_MYSQLTESTDIR_FREEBSD "mysql-test")
++SET(INSTALL_SUPPORTFILESDIR_FREEBSD "support-files")
++#
++SET(INSTALL_MYSQLDATADIR_FREEBSD "data")
++SET(INSTALL_MYSQLKEYRINGDIR_FREEBSD "keyring")
++SET(INSTALL_SECURE_FILE_PRIVDIR_FREEBSD ${secure_file_priv_path})
++
++#
+ # TARGZ layout
+ #
+ SET(INSTALL_BINDIR_TARGZ "bin")
+@@ -366,7 +396,7 @@ SET(ROUTER_INSTALL_LAYOUT "${DEFAULT_ROUTER_INSTALL_LA
+ SET(ROUTER_INSTALL_LAYOUT "${DEFAULT_ROUTER_INSTALL_LAYOUT}"
+ CACHE
+ STRING
+- "Installation directory layout. Options are: STANDALONE RPM DEB SVR4 TARGZ")
++ "Installation directory layout. Options are: STANDALONE FREEBSD RPM DEB SVR4 TARGZ")
+
+ # If we are shared STANDALONE with the the server, we shouldn't write
+ # into the server's data/ as that would create a "schemadir" in
+@@ -410,6 +440,21 @@ ENDFOREACH()
+ )
+ SET(ROUTER_INSTALL_${var}DIR_TARGZ ${ROUTER_INSTALL_${var}DIR_STANDALONE})
+ ENDFOREACH()
++
++#
++# FreeBSD layout
++#
++SET(ROUTER_INSTALL_CONFIGDIR_FREEBSD "/usr/local/etc/mysqlrouter")
++SET(ROUTER_INSTALL_DATADIR_FREEBSD "/var/db/mysqlrouter")
++SET(ROUTER_INSTALL_LOGDIR_FREEBSD "/var/log/mysqlrouter")
++SET(ROUTER_INSTALL_RUNTIMEDIR_FREEBSD "/var/run/mysqlrouter")
*** 2083 LINES SKIPPED ***