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

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
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
  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. libunwind.so : devel/libunwind
  8. libedit.so.0 : devel/libedit
  9. 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.26: ====> 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 (7 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. ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-8.0/
  5. http://download.softagency.net/MySQL/Downloads/MySQL-8.0/
  6. http://mirrors.ntua.gr/MySQL/Downloads/MySQL-8.0/
  7. http://mysql.mirrors.pair.com/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.26
29 Aug 2021 09:53:36
commit hash: ee47d22c17af06a9f4d743ebe68e483277915272commit hash: ee47d22c17af06a9f4d743ebe68e483277915272commit hash: ee47d22c17af06a9f4d743ebe68e483277915272commit hash: ee47d22c17af06a9f4d743ebe68e483277915272 files touched by this commit This port version is marked as vulnerable.
Bernard Spil (brnrd) search for other commits by this committer
Author: Jochen Neumeister
databases/mysql80-*: update to 8.0.26

Release notes: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-26.html

Sponsored by:	Netzkommune GmbH
Security:	38a4a043-e937-11eb-9b84-d4c9ef517024

(cherry picked from commit 84cc7ae5a0d131c991067d32bd0fae872a039cb9)

Number of commits found: 1