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
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details on branch 2022Q2
mysql57-server Multithreaded SQL database (server)
5.7.38 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 5.7.38Version of this port present on the latest quarterly branch.
Maintainer: joneum@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2022-04-30 10:36:04
Last Update: 2022-04-30 10:34:57
Commit Hash: f75424e
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. WWW: https://www.mysql.com/
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
pkg-plist: as obtained via: make generate-plist
Expand this list (168 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/mysql57-server-5.7.38/catalog.mk
  3. /usr/local/share/licenses/mysql57-server-5.7.38/LICENSE
  4. /usr/local/share/licenses/mysql57-server-5.7.38/GPLv2
  5. bin/innochecksum
  6. bin/lz4_decompress
  7. bin/my_print_defaults
  8. bin/myisam_ftdump
  9. bin/myisamchk
  10. bin/myisamlog
  11. bin/myisampack
  12. bin/mysql_install_db
  13. bin/mysql_plugin
  14. bin/mysql_secure_installation
  15. bin/mysql_tzinfo_to_sql
  16. bin/mysql_upgrade
  17. bin/mysqld_multi
  18. bin/mysqld_safe
  19. bin/mysqldumpslow
  20. bin/mysqltest
  21. bin/mysqlxtest
  22. bin/perror
  23. bin/replace
  24. bin/resolve_stack_dump
  25. bin/resolveip
  26. bin/zlib_decompress
  27. lib/mysql/libmysqld.a
  28. lib/mysql/plugin/adt_null.so
  29. lib/mysql/plugin/auth.so
  30. lib/mysql/plugin/auth_test_plugin.so
  31. lib/mysql/plugin/connection_control.so
  32. lib/mysql/plugin/daemon_example.ini
  33. lib/mysql/plugin/group_replication.so
  34. lib/mysql/plugin/ha_example.so
  35. lib/mysql/plugin/keyring_file.so
  36. lib/mysql/plugin/keyring_udf.so
  37. lib/mysql/plugin/libdaemon_example.so
  38. lib/mysql/plugin/libtest_framework.so
  39. lib/mysql/plugin/libtest_services.so
  40. lib/mysql/plugin/libtest_services_threaded.so
  41. lib/mysql/plugin/libtest_session_detach.so
  42. lib/mysql/plugin/libtest_session_in_thd.so
  43. lib/mysql/plugin/libtest_session_info.so
  44. lib/mysql/plugin/libtest_sql_2_sessions.so
  45. lib/mysql/plugin/libtest_sql_all_col_types.so
  46. lib/mysql/plugin/libtest_sql_cmds_1.so
  47. lib/mysql/plugin/libtest_sql_commit.so
  48. lib/mysql/plugin/libtest_sql_complex.so
  49. lib/mysql/plugin/libtest_sql_errors.so
  50. lib/mysql/plugin/libtest_sql_lock.so
  51. lib/mysql/plugin/libtest_sql_processlist.so
  52. lib/mysql/plugin/libtest_sql_replication.so
  53. lib/mysql/plugin/libtest_sql_shutdown.so
  54. lib/mysql/plugin/libtest_sql_sqlmode.so
  55. lib/mysql/plugin/libtest_sql_stored_procedures_functions.so
  56. lib/mysql/plugin/libtest_sql_views_triggers.so
  57. lib/mysql/plugin/libtest_x_sessions_deinit.so
  58. lib/mysql/plugin/libtest_x_sessions_init.so
  59. lib/mysql/plugin/locking_service.so
  60. lib/mysql/plugin/mypluglib.so
  61. lib/mysql/plugin/mysql_no_login.so
  62. lib/mysql/plugin/mysqlx.so
  63. lib/mysql/plugin/qa_auth_client.so
  64. lib/mysql/plugin/qa_auth_interface.so
  65. lib/mysql/plugin/qa_auth_server.so
  66. lib/mysql/plugin/replication_observers_example_plugin.so
  67. lib/mysql/plugin/rewrite_example.so
  68. lib/mysql/plugin/rewriter.so
  69. lib/mysql/plugin/semisync_master.so
  70. lib/mysql/plugin/semisync_slave.so
  71. lib/mysql/plugin/test_security_context.so
  72. lib/mysql/plugin/test_udf_services.so
  73. @comment lib/mysql/plugin/udf_example.so
  74. lib/mysql/plugin/validate_password.so
  75. lib/mysql/plugin/version_token.so
  76. libexec/mysqld
  77. man/man1/my_print_defaults.1.gz
  78. man/man1/myisam_ftdump.1.gz
  79. man/man1/myisamchk.1.gz
  80. man/man1/myisamlog.1.gz
  81. man/man1/myisampack.1.gz
  82. man/man1/mysql.server.1.gz
  83. man/man1/mysql_install_db.1.gz
  84. man/man1/mysql_plugin.1.gz
  85. man/man1/mysql_secure_installation.1.gz
  86. man/man1/mysql_tzinfo_to_sql.1.gz
  87. man/man1/mysql_upgrade.1.gz
  88. man/man1/mysqld_multi.1.gz
  89. man/man1/mysqld_safe.1.gz
  90. man/man1/mysqldumpslow.1.gz
  91. man/man1/mysqlman.1.gz
  92. man/man1/perror.1.gz
  93. man/man1/replace.1.gz
  94. man/man1/resolve_stack_dump.1.gz
  95. man/man1/resolveip.1.gz
  96. man/man8/mysqld.8.gz
  97. share/mysql/bulgarian/errmsg.sys
  98. share/mysql/charsets/Index.xml
  99. share/mysql/charsets/README
  100. share/mysql/charsets/armscii8.xml
  101. share/mysql/charsets/ascii.xml
  102. share/mysql/charsets/cp1250.xml
  103. share/mysql/charsets/cp1251.xml
  104. share/mysql/charsets/cp1256.xml
  105. share/mysql/charsets/cp1257.xml
  106. share/mysql/charsets/cp850.xml
  107. share/mysql/charsets/cp852.xml
  108. share/mysql/charsets/cp866.xml
  109. share/mysql/charsets/dec8.xml
  110. share/mysql/charsets/geostd8.xml
  111. share/mysql/charsets/greek.xml
  112. share/mysql/charsets/hebrew.xml
  113. share/mysql/charsets/hp8.xml
  114. share/mysql/charsets/keybcs2.xml
  115. share/mysql/charsets/koi8r.xml
  116. share/mysql/charsets/koi8u.xml
  117. share/mysql/charsets/latin1.xml
  118. share/mysql/charsets/latin2.xml
  119. share/mysql/charsets/latin5.xml
  120. share/mysql/charsets/latin7.xml
  121. share/mysql/charsets/macce.xml
  122. share/mysql/charsets/macroman.xml
  123. share/mysql/charsets/swe7.xml
  124. share/mysql/czech/errmsg.sys
  125. share/mysql/danish/errmsg.sys
  126. share/mysql/dictionary.txt
  127. share/mysql/dutch/errmsg.sys
  128. share/mysql/english/errmsg.sys
  129. share/mysql/errmsg-utf8.txt
  130. share/mysql/estonian/errmsg.sys
  131. share/mysql/fill_help_tables.sql
  132. share/mysql/french/errmsg.sys
  133. share/mysql/german/errmsg.sys
  134. share/mysql/greek/errmsg.sys
  135. share/mysql/hungarian/errmsg.sys
  136. share/mysql/innodb_memcached_config.sql
  137. share/mysql/install_rewriter.sql
  138. share/mysql/italian/errmsg.sys
  139. share/mysql/japanese/errmsg.sys
  140. share/mysql/korean/errmsg.sys
  141. share/mysql/magic
  142. share/mysql/mysql-log-rotate
  143. share/mysql/mysql.server
  144. share/mysql/mysql_security_commands.sql
  145. share/mysql/mysql_sys_schema.sql
  146. share/mysql/mysql_system_tables.sql
  147. share/mysql/mysql_system_tables_data.sql
  148. share/mysql/mysql_test_data_timezone.sql
  149. share/mysql/mysqld_multi.server
  150. share/mysql/norwegian-ny/errmsg.sys
  151. share/mysql/norwegian/errmsg.sys
  152. share/mysql/polish/errmsg.sys
  153. share/mysql/portuguese/errmsg.sys
  154. share/mysql/romanian/errmsg.sys
  155. share/mysql/russian/errmsg.sys
  156. share/mysql/serbian/errmsg.sys
  157. share/mysql/slovak/errmsg.sys
  158. share/mysql/spanish/errmsg.sys
  159. share/mysql/swedish/errmsg.sys
  160. share/mysql/ukrainian/errmsg.sys
  161. share/mysql/uninstall_rewriter.sql
  162. @sample(root,wheel,0644) etc/mysql/my.cnf.sample
  163. @dir(mysql,mysql,0750) etc/mysql/keyring
  164. @dir(mysql,mysql,0750) /var/db/mysql_secure
  165. @dir(mysql,mysql,0750) /var/db/mysql_tmpdir
  166. @owner
  167. @group
  168. @mode
Collapse this list.
Dependency lines:
  • mysql57-server>0:databases/mysql57-server
Conflicts:
CONFLICTS_INSTALL:
  • mysql*-server
  • mysqlwsrep*-server
  • mariadb*-server
  • percona*-server
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
To install the port:
cd /usr/ports/databases/mysql57-server/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/mysql57-server
  • pkg install mysql57-server
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: mysql57-server
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1651211695 SHA256 (mysql-boost-5.7.38.tar.gz) = 89d2c42aaa7fd2e31f33b21c5619d2b4c7e1dc2081f820f9f6eec2f30c5fbbf8 SIZE (mysql-boost-5.7.38.tar.gz) = 52973240

No package information for this port in our database
Sometimes this happens. Not all ports have packages.
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. bison : devel/bison
  2. cmake : devel/cmake
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. liblz4.so : archivers/liblz4
  4. libprotobuf.so : devel/protobuf
  5. libedit.so.0 : devel/libedit
  6. libmysqlclient.so.20 : databases/mysql57-client
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for mysql57-server-5.7.38: ====> 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_mysql57-server
USES:
bison:build cmake:noninja compiler:c11 compiler:c++11-lib cpe groff:run libedit localbase perl5 shebangfix ssl mysql:57
pkg-message:
For install:
Initial password for first time use of MySQL is saved in $HOME/.mysql_secret ie. when you want to use "mysql -u root -p" first you should see password in /root/.mysql_secret MySQL57 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
Remember to run mysql_upgrade the first time you start the MySQL server after an upgrade from an earlier version.
Master Sites:
Expand this list (7 items)
Collapse this list.
  1. ftp://ftp.fi.muni.cz/pub/mysql/Downloads/MySQL-5.7/
  2. ftp://ftp.gwdg.de/pub/misc/mysql/Downloads/MySQL-5.7/
  3. ftp://ftp.ntua.gr/pub/databases/mysql/Downloads/MySQL-5.7/
  4. ftp://mirror.switch.ch/mirror/mysql/Downloads/MySQL-5.7/
  5. http://download.softagency.net/MySQL/Downloads/MySQL-5.7/
  6. http://mirrors.ntua.gr/MySQL/Downloads/MySQL-5.7/
  7. http://mysql.mirrors.pair.com/Downloads/MySQL-5.7/
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
5.7.38
30 Apr 2022 10:34:57
commit hash: f75424e8ff81188a486e127eda0409cd5b042130commit hash: f75424e8ff81188a486e127eda0409cd5b042130commit hash: f75424e8ff81188a486e127eda0409cd5b042130commit hash: f75424e8ff81188a486e127eda0409cd5b042130 files touched by this commit This port version is marked as vulnerable.
Jochen Neumeister (joneum) search for other commits by this committer
databases/mysql57-*: Update ti 5.7.38

Bugs Fixed

    InnoDB: A missing null pointer check for an index instance caused a failure.
(Bug #33600109)

    InnoDB: Purge threads processed undo records of an encrypted table for which
the tablespace was not loaded, causing a failure. (Bug #32586721)

    InnoDB: Incorrect AUTO_INCREMENT values were generated when the maximum
integer column value was exceeded. The error was due to the maximum column value
not being considered. The previous valid AUTO_INCREMENT value should have been
returned in this case, causing a duplicate key error. (Bug #87926, Bug
#26906787)

    Partitioning: In some cases, establishing a connection to MySQL server could
fail if the .ibd file for a partition was missing. (Bug #33459653)

    Statements that cannot be parsed (due, for example, to syntax errors) are no
longer written to the slow query log. (Bug #33732907)

    It was not possible to revoke the DROP privilege on the Performance Schema.
(Bug #33578113)
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 1