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

Bot filter coming soon

To deter bots pegging the database CPU to 100%, a bot testing filter to be added to the website. This should not affect newsfeeds etc. Anubis seems light-weight - it''''''''s already in use within the FreeBSD Project. This notice is just a heads up in case you see something odd. This notice will be updated after Anubis is installed.

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

Packages (timestamps in pop-ups are UTC):
mysql80-server
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest8.0.418.0.42-8.0.418.0.42-8.0.22_1-
FreeBSD:13:quarterly8.0.418.0.418.0.32_38.0.418.0.41-8.0.35_18.0.35_1
FreeBSD:14:latest8.0.418.0.428.0.318.0.418.0.42--8.0.32_3
FreeBSD:14:quarterly8.0.418.0.41-8.0.39_18.0.41-8.0.35_18.0.35_1
FreeBSD:15:latest8.0.418.0.42n/a8.0.41n/a-8.0.35_18.0.35_1
Slave ports:
  1. databases/mysql80-client
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.32.r0<5.33 : lang/perl5.32
Library dependencies:
  1. libcurl.so : ftp/curl
  2. libevent.so : devel/libevent
  3. libicutu.so : devel/icu
  4. liblz4.so : archivers/liblz4
  5. libzstd.so : archivers/zstd
  6. libprotobuf.so : devel/protobuf
  7. libfido2.so : security/libfido2
  8. libhidapi.so : comms/hidapi
  9. libunwind.so : devel/libunwind
  10. libedit.so.0 : devel/libedit
  11. libmysqlclient.so.21 : databases/mysql80-client
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for mysql80-server-8.0.30: ====> 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_mysql80-server
USES:
bison:build cmake:noninja compiler:c++17-lang cpe groff:run libedit localbase ncurses perl5 pkgconfig shebangfix ssl mysql:80
pkg-message:
For install:
There is no initial password for first time use of MySQL. Keep in mind to reset it to a secure password. MySQL80 has a default /usr/local/etc/mysql/my.cnf, remember to replace it with your own or set `mysql_optfile="$YOUR_CNF_FILE` in rc.conf.
If upgrading
As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade. Consequently, mysql_upgrade is unneeded and is deprecated as of that version, and will be removed in a future MySQL version. Because mysql_upgrade no longer performs upgrade tasks, it exits with status 0 unconditionally.
Master Sites:
Expand this list (4 items)
Collapse this list.
  1. ftp://ftp.fi.muni.cz/pub/mysql/Downloads/MySQL-8.0/
  2. ftp://ftp.gwdg.de/pub/misc/mysql/Downloads/MySQL-8.0/
  3. ftp://ftp.ntua.gr/pub/databases/mysql/Downloads/MySQL-8.0/
  4. https://dev.mysql.com/get/Downloads/MySQL-8.0/
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.0.30
07 Dec 2022 18:45:39
commit hash: fbef78e7a9a85b3026c30e1d47a2ca85106ba34ccommit hash: fbef78e7a9a85b3026c30e1d47a2ca85106ba34ccommit hash: fbef78e7a9a85b3026c30e1d47a2ca85106ba34ccommit hash: fbef78e7a9a85b3026c30e1d47a2ca85106ba34c files touched by this commit This port version is marked as vulnerable.
Florian Smeets (flo) search for other commits by this committer
Author: Jochen Neumeister
databases/mysql80-server: fix build on armv7

PR:	267422
Sponsored by:	Netzkommune GmbH
Submitted by:	Robert Clausecker <fuz@fuz.su>

(cherry picked from commit 315977f1bd5da135727487a9d615963bfb7f94e7)

Number of commits found: 1