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 photos
All times are UTC
Ukraine
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
Port details on branch 2020Q3
mysql80-server Multithreaded SQL database (server)
8.0.21 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.21Version of this port present on the latest quarterly branch.
Maintainer: joneum@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2020-07-14 18:03:27
Last Update: 2020-09-03 18:54:05
Commit Hash: c188b03
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

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (238 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/mysql80-server-8.0.21/catalog.mk
  3. /usr/local/share/licenses/mysql80-server-8.0.21/LICENSE
  4. /usr/local/share/licenses/mysql80-server-8.0.21/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_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/mysqlrouter
  22. bin/mysqlrouter_keyring
  23. bin/mysqlrouter_passwd
  24. bin/mysqlrouter_plugin_info
  25. bin/mysqltest
  26. bin/mysqltest_safe_process
  27. bin/mysqlxtest
  28. lib/mysql/libmysqlharness.so
  29. lib/mysql/libmysqlharness.so.1
  30. lib/mysql/libmysqlrouter.so
  31. lib/mysql/libmysqlrouter.so.1
  32. lib/mysql/libmysqlrouter_http.so
  33. lib/mysql/libmysqlrouter_http.so.1
  34. lib/mysql/libmysqlrouter_http_auth_backend.so
  35. lib/mysql/libmysqlrouter_http_auth_backend.so.1
  36. lib/mysql/libmysqlrouter_http_auth_realm.so
  37. lib/mysql/libmysqlrouter_http_auth_realm.so.1
  38. lib/mysql/mysqlrouter/http_auth_backend.so
  39. lib/mysql/mysqlrouter/http_auth_realm.so
  40. lib/mysql/mysqlrouter/http_server.so
  41. lib/mysql/mysqlrouter/keepalive.so
  42. lib/mysql/mysqlrouter/metadata_cache.so
  43. lib/mysql/mysqlrouter/mysql_protocol.so
  44. lib/mysql/mysqlrouter/rest_api.so
  45. lib/mysql/mysqlrouter/rest_metadata_cache.so
  46. lib/mysql/mysqlrouter/rest_router.so
  47. lib/mysql/mysqlrouter/rest_routing.so
  48. lib/mysql/mysqlrouter/router_protobuf.so
  49. lib/mysql/mysqlrouter/routing.so
  50. lib/mysql/plugin/adt_null.so
  51. lib/mysql/plugin/auth.so
  52. lib/mysql/plugin/auth_test_plugin.so
  53. lib/mysql/plugin/component_audit_api_message_emit.so
  54. lib/mysql/plugin/component_example_component1.so
  55. lib/mysql/plugin/component_example_component2.so
  56. lib/mysql/plugin/component_example_component3.so
  57. lib/mysql/plugin/component_log_filter_dragnet.so
  58. lib/mysql/plugin/component_log_sink_json.so
  59. lib/mysql/plugin/component_log_sink_syseventlog.so
  60. lib/mysql/plugin/component_log_sink_test.so
  61. lib/mysql/plugin/component_mysqlbackup.so
  62. lib/mysql/plugin/component_mysqlx_global_reset.so
  63. lib/mysql/plugin/component_pfs_example.so
  64. lib/mysql/plugin/component_pfs_example_component_population.so
  65. lib/mysql/plugin/component_test_audit_api_message.so
  66. lib/mysql/plugin/component_test_backup_lock_service.so
  67. lib/mysql/plugin/component_test_component_deinit.so
  68. lib/mysql/plugin/component_test_host_application_signal.so
  69. lib/mysql/plugin/component_test_mysql_current_thread_reader.so
  70. lib/mysql/plugin/component_test_mysql_runtime_error.so
  71. lib/mysql/plugin/component_test_pfs_notification.so
  72. lib/mysql/plugin/component_test_pfs_resource_group.so
  73. lib/mysql/plugin/component_test_status_var_service.so
  74. lib/mysql/plugin/component_test_status_var_service_int.so
  75. lib/mysql/plugin/component_test_status_var_service_reg_only.so
  76. lib/mysql/plugin/component_test_status_var_service_str.so
  77. lib/mysql/plugin/component_test_status_var_service_unreg_only.so
  78. lib/mysql/plugin/component_test_string_service.so
  79. lib/mysql/plugin/component_test_string_service_charset.so
  80. lib/mysql/plugin/component_test_string_service_long.so
  81. lib/mysql/plugin/component_test_sys_var_service.so
  82. lib/mysql/plugin/component_test_sys_var_service_int.so
  83. lib/mysql/plugin/component_test_sys_var_service_same.so
  84. lib/mysql/plugin/component_test_sys_var_service_str.so
  85. lib/mysql/plugin/component_test_system_variable_source.so
  86. lib/mysql/plugin/component_test_udf_registration.so
  87. @comment lib/mysql/plugin/component_test_udf_services.so
  88. lib/mysql/plugin/component_udf_reg_3_func.so
  89. lib/mysql/plugin/component_udf_reg_avg_func.so
  90. lib/mysql/plugin/component_udf_reg_int_func.so
  91. lib/mysql/plugin/component_udf_reg_int_same_func.so
  92. lib/mysql/plugin/component_udf_reg_only_3_func.so
  93. lib/mysql/plugin/component_udf_reg_real_func.so
  94. lib/mysql/plugin/component_udf_unreg_3_func.so
  95. lib/mysql/plugin/component_udf_unreg_int_func.so
  96. lib/mysql/plugin/component_udf_unreg_real_func.so
  97. lib/mysql/plugin/component_validate_password.so
  98. lib/mysql/plugin/connection_control.so
  99. lib/mysql/plugin/daemon_example.ini
  100. lib/mysql/plugin/ddl_rewriter.so
  101. lib/mysql/plugin/group_replication.so
  102. lib/mysql/plugin/ha_example.so
  103. lib/mysql/plugin/ha_mock.so
  104. lib/mysql/plugin/component_test_udf_services.so
  105. lib/mysql/plugin/keyring_file.so
  106. lib/mysql/plugin/libdaemon_example.so
  107. lib/mysql/plugin/libtest_framework.so
  108. lib/mysql/plugin/libtest_services.so
  109. lib/mysql/plugin/libtest_services_threaded.so
  110. lib/mysql/plugin/libtest_session_attach.so
  111. lib/mysql/plugin/libtest_session_detach.so
  112. lib/mysql/plugin/libtest_session_in_thd.so
  113. lib/mysql/plugin/libtest_session_info.so
  114. lib/mysql/plugin/libtest_sql_2_sessions.so
  115. lib/mysql/plugin/libtest_sql_all_col_types.so
  116. lib/mysql/plugin/libtest_sql_cmds_1.so
  117. lib/mysql/plugin/libtest_sql_commit.so
  118. lib/mysql/plugin/libtest_sql_complex.so
  119. lib/mysql/plugin/libtest_sql_errors.so
  120. lib/mysql/plugin/libtest_sql_lock.so
  121. lib/mysql/plugin/libtest_sql_processlist.so
  122. lib/mysql/plugin/libtest_sql_replication.so
  123. lib/mysql/plugin/libtest_sql_reset_connection.so
  124. lib/mysql/plugin/libtest_sql_shutdown.so
  125. lib/mysql/plugin/libtest_sql_sqlmode.so
  126. lib/mysql/plugin/libtest_sql_stmt.so
  127. lib/mysql/plugin/libtest_sql_stored_procedures_functions.so
  128. lib/mysql/plugin/libtest_sql_views_triggers.so
  129. lib/mysql/plugin/libtest_x_sessions_deinit.so
  130. lib/mysql/plugin/libtest_x_sessions_init.so
  131. lib/mysql/plugin/locking_service.so
  132. lib/mysql/plugin/mypluglib.so
  133. lib/mysql/plugin/mysql_clone.so
  134. lib/mysql/plugin/mysql_no_login.so
  135. lib/mysql/plugin/pfs_example_plugin_employee.so
  136. lib/mysql/plugin/qa_auth_client.so
  137. lib/mysql/plugin/qa_auth_interface.so
  138. lib/mysql/plugin/qa_auth_server.so
  139. lib/mysql/plugin/replication_observers_example_plugin.so
  140. lib/mysql/plugin/rewrite_example.so
  141. lib/mysql/plugin/rewriter.so
  142. lib/mysql/plugin/semisync_master.so
  143. lib/mysql/plugin/semisync_slave.so
  144. lib/mysql/plugin/test_security_context.so
  145. lib/mysql/plugin/test_services_host_application_signal.so
  146. lib/mysql/plugin/test_services_plugin_registry.so
  147. lib/mysql/plugin/udf_example.so
  148. lib/mysql/plugin/keyring_udf.so
  149. lib/mysql/plugin/test_udf_services.so
  150. lib/mysql/plugin/validate_password.so
  151. lib/mysql/plugin/version_token.so
  152. libexec/mysqld
  153. man/man1/ibd2sdi.1.gz
  154. man/man1/innochecksum.1.gz
  155. man/man1/my_print_defaults.1.gz
  156. man/man1/myisam_ftdump.1.gz
  157. man/man1/myisamchk.1.gz
  158. man/man1/myisamlog.1.gz
  159. man/man1/myisampack.1.gz
  160. man/man1/mysql_secure_installation.1.gz
  161. man/man1/mysql_ssl_rsa_setup.1.gz
  162. man/man1/mysql_tzinfo_to_sql.1.gz
  163. man/man1/mysql_upgrade.1.gz
  164. man/man1/mysql.server.1.gz
  165. man/man1/mysqld_multi.1.gz
  166. man/man1/mysqld_safe.1.gz
  167. man/man1/mysqldumpslow.1.gz
  168. man/man1/mysqlrouter_passwd.1.gz
  169. man/man1/mysqlrouter_plugin_info.1.gz
  170. man/man1/mysqlrouter.1.gz
  171. man/man8/mysqld.8.gz
  172. share/mysql/bulgarian/errmsg.sys
  173. share/mysql/charsets/Index.xml
  174. share/mysql/charsets/README
  175. share/mysql/charsets/armscii8.xml
  176. share/mysql/charsets/ascii.xml
  177. share/mysql/charsets/cp1250.xml
  178. share/mysql/charsets/cp1251.xml
  179. share/mysql/charsets/cp1256.xml
  180. share/mysql/charsets/cp1257.xml
  181. share/mysql/charsets/cp850.xml
  182. share/mysql/charsets/cp852.xml
  183. share/mysql/charsets/cp866.xml
  184. share/mysql/charsets/dec8.xml
  185. share/mysql/charsets/geostd8.xml
  186. share/mysql/charsets/greek.xml
  187. share/mysql/charsets/hebrew.xml
  188. share/mysql/charsets/hp8.xml
  189. share/mysql/charsets/keybcs2.xml
  190. share/mysql/charsets/koi8r.xml
  191. share/mysql/charsets/koi8u.xml
  192. share/mysql/charsets/latin1.xml
  193. share/mysql/charsets/latin2.xml
  194. share/mysql/charsets/latin5.xml
  195. share/mysql/charsets/latin7.xml
  196. share/mysql/charsets/macce.xml
  197. share/mysql/charsets/macroman.xml
  198. share/mysql/charsets/swe7.xml
  199. share/mysql/czech/errmsg.sys
  200. share/mysql/danish/errmsg.sys
  201. share/mysql/dictionary.txt
  202. share/mysql/dutch/errmsg.sys
  203. share/mysql/english/errmsg.sys
  204. share/mysql/estonian/errmsg.sys
  205. share/mysql/french/errmsg.sys
  206. share/mysql/german/errmsg.sys
  207. share/mysql/greek/errmsg.sys
  208. share/mysql/hungarian/errmsg.sys
  209. share/mysql/innodb_memcached_config.sql
  210. share/mysql/install_rewriter.sql
  211. share/mysql/italian/errmsg.sys
  212. share/mysql/japanese/errmsg.sys
  213. share/mysql/korean/errmsg.sys
  214. share/mysql/messages_to_clients.txt
  215. share/mysql/messages_to_error_log.txt
  216. share/mysql/mysql-log-rotate
  217. share/mysql/mysql.server
  218. share/mysql/mysqld_multi.server
  219. share/mysql/norwegian-ny/errmsg.sys
  220. share/mysql/norwegian/errmsg.sys
  221. share/mysql/polish/errmsg.sys
  222. share/mysql/portuguese/errmsg.sys
  223. share/mysql/romanian/errmsg.sys
  224. share/mysql/russian/errmsg.sys
  225. share/mysql/serbian/errmsg.sys
  226. share/mysql/slovak/errmsg.sys
  227. share/mysql/spanish/errmsg.sys
  228. share/mysql/swedish/errmsg.sys
  229. share/mysql/ukrainian/errmsg.sys
  230. share/mysql/uninstall_rewriter.sql
  231. @dir lib/mysql/plugin/debug
  232. @sample(root,wheel,0644) etc/mysql/my.cnf.sample
  233. @dir(mysql,mysql,0750) etc/mysql/keyring
  234. @dir(mysql,mysql,0750) /var/db/mysql_secure
  235. @dir(mysql,mysql,0750) /var/db/mysql_tmpdir
  236. @owner
  237. @group
  238. @mode
Collapse this list.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
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 = 1594631042 SHA256 (mysql-boost-8.0.21.tar.gz) = 37231a123372a95f409857364dc1deb196b6f2c0b1fe60cc8382c7686b487f11 SIZE (mysql-boost-8.0.21.tar.gz) = 278292192

Packages (timestamps in pop-ups are UTC):
mysql80-server
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest---8.0.43-n/an/an/a
FreeBSD:13:quarterly8.0.458.0.458.0.32_38.0.428.0.45n/an/an/a
FreeBSD:14:latest8.0.458.0.458.0.318.0.438.0.45--8.0.32_3
FreeBSD:14:quarterly8.0.458.0.45-8.0.428.0.45-8.0.35_18.0.35_1
FreeBSD:15:latest8.0.458.0.45n/a8.0.42n/an/a8.0.35_18.0.35_1
FreeBSD:15:quarterly8.0.458.0.45n/a-n/an/a--
FreeBSD:16:latest8.0.458.0.45n/a-n/an/a--
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.30.r1<5.31 : lang/perl5.30
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.21: ====> 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++14-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 %%ETCDIR%%/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: 4

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
8.0.21
03 Sep 2020 18:54:05
commit hash: c188b0339e8f2c2887651d2594c344f1cadfdde1commit hash: c188b0339e8f2c2887651d2594c344f1cadfdde1commit hash: c188b0339e8f2c2887651d2594c344f1cadfdde1commit hash: c188b0339e8f2c2887651d2594c344f1cadfdde1 files touched by this commit This port version is marked as vulnerable.
Jochen Neumeister (joneum) search for other commits by this committer
MFH: r547473

fix build on current
- add temporary work around to use llvm from ports on recent currents

Sponsored by:	Netzkommune GmbH

Approved by:	ports-secteam (with hat)
8.0.21
03 Sep 2020 18:54:05
Revision:547474Original commit files touched by this commit This port version is marked as vulnerable.
joneum search for other commits by this committer
MFH: r547473

fix build on current
- add temporary work around to use llvm from ports on recent currents

Sponsored by:	Netzkommune GmbH

Approved by:	ports-secteam (with hat)
8.0.21
14 Jul 2020 18:03:21
commit hash: fb709346647f89219fe230eaa46fdf84b471cf24commit hash: fb709346647f89219fe230eaa46fdf84b471cf24commit hash: fb709346647f89219fe230eaa46fdf84b471cf24commit hash: fb709346647f89219fe230eaa46fdf84b471cf24 files touched by this commit This port version is marked as vulnerable.
Jochen Neumeister (joneum) search for other commits by this committer
MFH: r542227

databases/mysql80-{client, server}: Update to latest release 8.0.21

Full Changelog: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-21.html

Submitted by:	fluffy
Security:	0ed71663-c369-11ea-b53c-d4c9ef517024
Sponsored by:	Netzkommune GmbH

Approved by:	ports-secteam (with hat)
8.0.21
14 Jul 2020 18:03:21
Revision:542228Original commit files touched by this commit This port version is marked as vulnerable.
joneum search for other commits by this committer
MFH: r542227

databases/mysql80-{client, server}: Update to latest release 8.0.21

Full Changelog: https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-21.html

Submitted by:	fluffy
Security:	0ed71663-c369-11ea-b53c-d4c9ef517024
Sponsored by:	Netzkommune GmbH

Approved by:	ports-secteam (with hat)

Number of commits found: 4