notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
Port details on branch 2024Q1
mysql81-server Multithreaded SQL database (server)
8.1.0 databases on this many watch lists=0 search for ports that depend on this port This port version is marked as vulnerable. Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 8.1.0Version of this port present on the latest quarterly branch.
Maintainer: joneum@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2024-04-06 17:28:05
Last Update: 2024-04-06 17:26:12
Commit Hash: 154a19d
License: GPLv2
WWW:
https://www.mysql.com/
Description:
MySQL is a very fast, multi-threaded, multi-user and robust SQL (Structured Query Language) database server. The new features in MySQL 8.0. In addition to Data Dictionnary and CTEs are: Move to utf8(mb4) as MySQL's default character set Language specific case insensitive collation for 21 languages (utf8) Invisible index Descending indexes Improve usability of UUID and IPV6 manipulations SQL roles - SET PERSIST for global variable values Performance Schema, instrumenting data locks Performance Schema, instrumenting error messages Improved cost model with histograms
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (260 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/mysql81-server-8.1.0/catalog.mk
  3. /usr/local/share/licenses/mysql81-server-8.1.0/LICENSE
  4. /usr/local/share/licenses/mysql81-server-8.1.0/GPLv2
  5. LICENSE.router
  6. README.router
  7. bin/ibd2sdi
  8. bin/innochecksum
  9. bin/myisam_ftdump
  10. bin/myisamchk
  11. bin/myisamlog
  12. bin/myisampack
  13. bin/mysql_client_test
  14. bin/mysql_keyring_encryption_test
  15. bin/mysql_secure_installation
  16. bin/mysql_ssl_rsa_setup
  17. bin/mysql_test_event_tracking
  18. bin/mysql_tzinfo_to_sql
  19. bin/mysql_upgrade
  20. bin/mysqld_multi
  21. bin/mysqld_safe
  22. bin/mysqldumpslow
  23. bin/mysqlrouter
  24. bin/mysqlrouter_keyring
  25. bin/mysqlrouter_passwd
  26. bin/mysqlrouter_plugin_info
  27. bin/mysqltest
  28. bin/mysqltest_safe_process
  29. bin/mysqlxtest
  30. etc/logrotate.d/mysqlrouter
  31. etc/mysql/my.cnf.sample
  32. lib/mysql/libmysqlharness.so
  33. lib/mysql/libmysqlharness.so.1
  34. lib/mysql/libmysqlharness_stdx.so
  35. lib/mysql/libmysqlharness_stdx.so.1
  36. lib/mysql/libmysqlharness_tls.so
  37. lib/mysql/libmysqlharness_tls.so.1
  38. lib/mysql/libmysqlrouter.so
  39. lib/mysql/libmysqlrouter.so.1
  40. lib/mysql/libmysqlrouter_connection_pool.so.1
  41. lib/mysql/libmysqlrouter_destination_status.so.1
  42. lib/mysql/libmysqlrouter_http.so
  43. lib/mysql/libmysqlrouter_http.so.1
  44. lib/mysql/libmysqlrouter_http_auth_backend.so
  45. lib/mysql/libmysqlrouter_http_auth_backend.so.1
  46. lib/mysql/libmysqlrouter_http_auth_realm.so
  47. lib/mysql/libmysqlrouter_http_auth_realm.so.1
  48. lib/mysql/libmysqlrouter_io_component.so
  49. lib/mysql/libmysqlrouter_io_component.so.1
  50. lib/mysql/libmysqlrouter_metadata_cache.so.1
  51. lib/mysql/libmysqlrouter_mysqlxmessages.so.1
  52. lib/mysql/libmysqlrouter_routing.so.1
  53. lib/mysql/libprotobuf-lite.so.3.19.4
  54. lib/mysql/mysqlrouter/connection_pool.so
  55. lib/mysql/mysqlrouter/destination_status.so
  56. lib/mysql/mysqlrouter/http_auth_backend.so
  57. lib/mysql/mysqlrouter/http_auth_realm.so
  58. lib/mysql/mysqlrouter/http_server.so
  59. lib/mysql/mysqlrouter/io.so
  60. lib/mysql/mysqlrouter/keepalive.so
  61. lib/mysql/mysqlrouter/metadata_cache.so
  62. lib/mysql/mysqlrouter/rest_api.so
  63. lib/mysql/mysqlrouter/rest_connection_pool.so
  64. lib/mysql/mysqlrouter/rest_metadata_cache.so
  65. lib/mysql/mysqlrouter/rest_router.so
  66. lib/mysql/mysqlrouter/rest_routing.so
  67. lib/mysql/mysqlrouter/router_openssl.so
  68. lib/mysql/mysqlrouter/router_protobuf.so
  69. lib/mysql/mysqlrouter/routing.so
  70. lib/mysql/plugin/adt_null.so
  71. lib/mysql/plugin/auth.so
  72. lib/mysql/plugin/auth_test_plugin.so
  73. lib/mysql/plugin/component_audit_api_message_emit.so
  74. lib/mysql/plugin/component_example_component1.so
  75. lib/mysql/plugin/component_example_component2.so
  76. lib/mysql/plugin/component_example_component3.so
  77. lib/mysql/plugin/component_keyring_file.so
  78. lib/mysql/plugin/component_log_filter_dragnet.so
  79. lib/mysql/plugin/component_log_sink_json.so
  80. lib/mysql/plugin/component_log_sink_syseventlog.so
  81. lib/mysql/plugin/component_log_sink_test.so
  82. lib/mysql/plugin/component_mysqlbackup.so
  83. lib/mysql/plugin/component_mysqlx_global_reset.so
  84. lib/mysql/plugin/component_pfs_example.so
  85. lib/mysql/plugin/component_pfs_example_component_population.so
  86. lib/mysql/plugin/component_query_attributes.so
  87. lib/mysql/plugin/component_reference_cache.so
  88. lib/mysql/plugin/component_test_audit_api_message.so
  89. lib/mysql/plugin/component_test_backup_lock_service.so
  90. lib/mysql/plugin/component_test_component_deinit.so
  91. lib/mysql/plugin/component_test_event_tracking_consumer.so
  92. lib/mysql/plugin/component_test_event_tracking_consumer_a.so
  93. lib/mysql/plugin/component_test_event_tracking_consumer_b.so
  94. lib/mysql/plugin/component_test_event_tracking_consumer_c.so
  95. lib/mysql/plugin/component_test_event_tracking_producer_a.so
  96. lib/mysql/plugin/component_test_event_tracking_producer_b.so
  97. lib/mysql/plugin/component_test_host_application_signal.so
  98. lib/mysql/plugin/component_test_mysql_command_services.so
  99. lib/mysql/plugin/component_test_mysql_current_thread_reader.so
  100. lib/mysql/plugin/component_test_mysql_runtime_error.so
  101. lib/mysql/plugin/component_test_mysql_system_variable_set.so
  102. lib/mysql/plugin/component_test_mysql_thd_store_service.so
  103. lib/mysql/plugin/component_test_pfs_notification.so
  104. lib/mysql/plugin/component_test_pfs_resource_group.so
  105. lib/mysql/plugin/component_test_sensitive_system_variables.so
  106. lib/mysql/plugin/component_test_server_telemetry_traces.so
  107. lib/mysql/plugin/component_test_status_var_reader.so
  108. lib/mysql/plugin/component_test_status_var_service.so
  109. lib/mysql/plugin/component_test_status_var_service_int.so
  110. lib/mysql/plugin/component_test_status_var_service_reg_only.so
  111. lib/mysql/plugin/component_test_status_var_service_str.so
  112. lib/mysql/plugin/component_test_status_var_service_unreg_only.so
  113. lib/mysql/plugin/component_test_string_service.so
  114. lib/mysql/plugin/component_test_string_service_charset.so
  115. lib/mysql/plugin/component_test_string_service_long.so
  116. lib/mysql/plugin/component_test_sys_var_service.so
  117. lib/mysql/plugin/component_test_sys_var_service_int.so
  118. lib/mysql/plugin/component_test_sys_var_service_same.so
  119. lib/mysql/plugin/component_test_sys_var_service_str.so
  120. lib/mysql/plugin/component_test_system_variable_source.so
  121. lib/mysql/plugin/component_test_table_access.so
  122. lib/mysql/plugin/component_test_udf_registration.so
  123. lib/mysql/plugin/component_test_udf_services.so
  124. lib/mysql/plugin/component_udf_reg_3_func.so
  125. lib/mysql/plugin/component_udf_reg_avg_func.so
  126. lib/mysql/plugin/component_udf_reg_int_func.so
  127. lib/mysql/plugin/component_udf_reg_int_same_func.so
  128. lib/mysql/plugin/component_udf_reg_only_3_func.so
  129. lib/mysql/plugin/component_udf_reg_real_func.so
  130. lib/mysql/plugin/component_udf_unreg_3_func.so
  131. lib/mysql/plugin/component_udf_unreg_int_func.so
  132. lib/mysql/plugin/component_udf_unreg_real_func.so
  133. lib/mysql/plugin/component_validate_password.so
  134. lib/mysql/plugin/conflicting_variables.so
  135. lib/mysql/plugin/connection_control.so
  136. lib/mysql/plugin/daemon_example.ini
  137. lib/mysql/plugin/ddl_rewriter.so
  138. lib/mysql/plugin/group_replication.so
  139. lib/mysql/plugin/ha_example.so
  140. lib/mysql/plugin/ha_mock.so
  141. lib/mysql/plugin/keyring_file.so
  142. lib/mysql/plugin/keyring_udf.so
  143. lib/mysql/plugin/libdaemon_example.so
  144. lib/mysql/plugin/libtest_framework.so
  145. lib/mysql/plugin/libtest_services.so
  146. lib/mysql/plugin/libtest_services_threaded.so
  147. lib/mysql/plugin/libtest_session_attach.so
  148. lib/mysql/plugin/libtest_session_detach.so
  149. lib/mysql/plugin/libtest_session_in_thd.so
  150. lib/mysql/plugin/libtest_session_info.so
  151. lib/mysql/plugin/libtest_sql_2_sessions.so
  152. lib/mysql/plugin/libtest_sql_all_col_types.so
  153. lib/mysql/plugin/libtest_sql_cmds_1.so
  154. lib/mysql/plugin/libtest_sql_commit.so
  155. lib/mysql/plugin/libtest_sql_complex.so
  156. lib/mysql/plugin/libtest_sql_errors.so
  157. lib/mysql/plugin/libtest_sql_lock.so
  158. lib/mysql/plugin/libtest_sql_processlist.so
  159. lib/mysql/plugin/libtest_sql_replication.so
  160. lib/mysql/plugin/libtest_sql_reset_connection.so
  161. lib/mysql/plugin/libtest_sql_shutdown.so
  162. lib/mysql/plugin/libtest_sql_sleep_is_connected.so
  163. lib/mysql/plugin/libtest_sql_sqlmode.so
  164. lib/mysql/plugin/libtest_sql_stmt.so
  165. lib/mysql/plugin/libtest_sql_stored_procedures_functions.so
  166. lib/mysql/plugin/libtest_sql_views_triggers.so
  167. lib/mysql/plugin/libtest_x_sessions_deinit.so
  168. lib/mysql/plugin/libtest_x_sessions_init.so
  169. lib/mysql/plugin/locking_service.so
  170. lib/mysql/plugin/mypluglib.so
  171. lib/mysql/plugin/mysql_clone.so
  172. lib/mysql/plugin/mysql_no_login.so
  173. lib/mysql/plugin/pfs_example_plugin_employee.so
  174. lib/mysql/plugin/qa_auth_client.so
  175. lib/mysql/plugin/qa_auth_interface.so
  176. lib/mysql/plugin/qa_auth_server.so
  177. lib/mysql/plugin/replication_observers_example_plugin.so
  178. lib/mysql/plugin/rewrite_example.so
  179. lib/mysql/plugin/rewriter.so
  180. lib/mysql/plugin/semisync_master.so
  181. lib/mysql/plugin/semisync_replica.so
  182. lib/mysql/plugin/semisync_slave.so
  183. lib/mysql/plugin/semisync_source.so
  184. lib/mysql/plugin/test_security_context.so
  185. lib/mysql/plugin/test_services_command_services.so
  186. lib/mysql/plugin/test_services_host_application_signal.so
  187. lib/mysql/plugin/test_services_plugin_registry.so
  188. lib/mysql/plugin/test_udf_services.so
  189. lib/mysql/plugin/udf_example.so
  190. lib/mysql/plugin/validate_password.so
  191. lib/mysql/plugin/version_token.so
  192. lib/mysql/private/libprotobuf-lite.so.3.19.4
  193. lib/mysql/private/libprotobuf.so.3.19.4
  194. libexec/mysqld
  195. share/mysql/bulgarian/errmsg.sys
  196. share/mysql/charsets/Index.xml
  197. share/mysql/charsets/README
  198. share/mysql/charsets/armscii8.xml
  199. share/mysql/charsets/ascii.xml
  200. share/mysql/charsets/cp1250.xml
  201. share/mysql/charsets/cp1251.xml
  202. share/mysql/charsets/cp1256.xml
  203. share/mysql/charsets/cp1257.xml
  204. share/mysql/charsets/cp850.xml
  205. share/mysql/charsets/cp852.xml
  206. share/mysql/charsets/cp866.xml
  207. share/mysql/charsets/dec8.xml
  208. share/mysql/charsets/geostd8.xml
  209. share/mysql/charsets/greek.xml
  210. share/mysql/charsets/hebrew.xml
  211. share/mysql/charsets/hp8.xml
  212. share/mysql/charsets/keybcs2.xml
  213. share/mysql/charsets/koi8r.xml
  214. share/mysql/charsets/koi8u.xml
  215. share/mysql/charsets/latin1.xml
  216. share/mysql/charsets/latin2.xml
  217. share/mysql/charsets/latin5.xml
  218. share/mysql/charsets/latin7.xml
  219. share/mysql/charsets/macce.xml
  220. share/mysql/charsets/macroman.xml
  221. share/mysql/charsets/swe7.xml
  222. share/mysql/czech/errmsg.sys
  223. share/mysql/danish/errmsg.sys
  224. share/mysql/dictionary.txt
  225. share/mysql/dutch/errmsg.sys
  226. share/mysql/english/errmsg.sys
  227. share/mysql/estonian/errmsg.sys
  228. share/mysql/french/errmsg.sys
  229. share/mysql/german/errmsg.sys
  230. share/mysql/greek/errmsg.sys
  231. share/mysql/hungarian/errmsg.sys
  232. share/mysql/install_rewriter.sql
  233. share/mysql/italian/errmsg.sys
  234. share/mysql/japanese/errmsg.sys
  235. share/mysql/korean/errmsg.sys
  236. share/mysql/messages_to_clients.txt
  237. share/mysql/messages_to_error_log.txt
  238. share/mysql/mysql-log-rotate
  239. share/mysql/mysql.server
  240. share/mysql/mysqld_multi.server
  241. share/mysql/norwegian-ny/errmsg.sys
  242. share/mysql/norwegian/errmsg.sys
  243. share/mysql/polish/errmsg.sys
  244. share/mysql/portuguese/errmsg.sys
  245. share/mysql/romanian/errmsg.sys
  246. share/mysql/russian/errmsg.sys
  247. share/mysql/serbian/errmsg.sys
  248. share/mysql/slovak/errmsg.sys
  249. share/mysql/spanish/errmsg.sys
  250. share/mysql/swedish/errmsg.sys
  251. share/mysql/ukrainian/errmsg.sys
  252. share/mysql/uninstall_rewriter.sql
  253. share/mysqlrouter/docs/sample_mysqlrouter.conf
  254. @dir etc/mysql/keyring
  255. @dir lib/mysql/plugin/debug
  256. @dir /var/db/mysql_secure
  257. @dir /var/db/mysql_tmpdir
  258. @owner
  259. @group
  260. @mode
Collapse this list.
Dependency lines:
  • mysql81-server>0:databases/mysql81-server
Conflicts:
CONFLICTS_INSTALL:
  • mysql*-server
  • mysqlwsrep*-server
  • mariadb*-server
  • percona*-server
To install the port:
cd /usr/ports/databases/mysql81-server/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/mysql81-server
  • pkg install mysql81-server
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: mysql81-server
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1695150470 SHA256 (mysql-boost-8.1.0.tar.gz) = cb19648bc8719b9f6979924bfea806b278bd26b8d67740e5742c6f363f142188 SIZE (mysql-boost-8.1.0.tar.gz) = 440038191

No package information for this port in our database
Sometimes this happens. Not all ports have packages. Perhaps there is a build error. Check the fallout link: pkg-fallout
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. liblz4>0 : archivers/liblz4
  2. libunwind>0 : devel/libunwind
  3. bison : devel/bison
  4. cmake : devel/cmake-core
  5. pkgconf>=1.3.0_1 : devel/pkgconf
Runtime dependencies:
  1. groff : textproc/groff
  2. perl5>=5.36<5.37 : lang/perl5.36
Library dependencies:
  1. libcurl.so : ftp/curl
  2. libevent.so : devel/libevent
  3. libicutu.so : devel/icu
  4. liblz4.so : archivers/liblz4
  5. libfido2.so : security/libfido2
  6. libhidapi.so : comms/hidapi
  7. libunwind.so : devel/libunwind
  8. libedit.so.0 : devel/libedit
  9. libmysqlclient.so.22 : databases/mysql81-client
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for mysql81-server-8.1.0: ====> Permissible Storage Engines (to compile statically into the server) ARCHIVE=off: Compile "Archive Storage" statically in server BLACKHOLE=off: Compile "Blackhole Storage" statically in server EXAMPLE=off: Compile "Example Storage" statically in server FEDERATED=off: Compile "Federated Storage" statically in server INNOBASE=off: Compile "InnoDB Storage" statically in server PARTITION=off: Compile "Partitioning support Storage" statically in server PERFSCHEMA=off: Compile "Performance Schema Storage" statically in server ====> Default features knobs PERFSCHM=on: Enable "Performance Schema" by default (High RAM usage) ===> Use 'make config' to modify these settings
Options name:
databases_mysql81-server
USES:
bison:build cmake:noninja cpe groff:run libedit localbase ncurses perl5 pkgconfig shebangfix ssl mysql:81 compiler:c++17-lang
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (3 items)
Collapse this list.
  1. ftp://ftp.fi.muni.cz/pub/mysql/Downloads/MySQL-8.1/
  2. ftp://ftp.gwdg.de/pub/misc/mysql/Downloads/MySQL-8.1/
  3. https://dev.mysql.com/get/Downloads/MySQL-8.1/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
8.1.0
06 Apr 2024 17:26:12
commit hash: 154a19da2a20a6f899d7e1e92c1ddc56447a0b00commit hash: 154a19da2a20a6f899d7e1e92c1ddc56447a0b00commit hash: 154a19da2a20a6f899d7e1e92c1ddc56447a0b00commit hash: 154a19da2a20a6f899d7e1e92c1ddc56447a0b00 files touched by this commit This port version is marked as vulnerable.
Dimitry Andric (dim) search for other commits by this committer
databases/mysql80-server databases/mysql81-server: fix build with libc++ 18 on
i386

When building against libc++ 18, several iostream classes now get
inlined into C++ binaries for efficiency. But because the mysql ports
use -malign-double on non-powerpc architectures, this causes an ABI
problem with libc++.so, which has not been built with that flag, at
least on i386. This can cause segfaults during the build of the port.

If it is not the architecture default, as it is on amd64, -malign-double
should not be used without recompiling basically the entire userspace
runtime. Quoting the gcc docs:

> Warning: if you use the -malign-double switch, structures containing
> the above types are aligned differently than the published application
> binary interface specifications for the x86-32 and are not binary
> compatible with structures in code compiled without that switch.

Hence, remove -malign-double from CXXFLAGS for these ports.

PR:		277896
Approved by:    maintainer timeout (2 weeks)
MFH:		2024Q1

(cherry picked from commit b49518c5c7c16418d7da0a5ce786da139b905bb1)

Number of commits found: 1