MySQL is a very fast, multi-threaded, multi-user and robust SQL
(Structured Query Language) database server. MySQL Server is intended for
mission-critical, heavy-load production systems as well as for embedding
into mass-deployed software
In the other systems
The newest version among them is 8.4.13, as upstream numbers it.
Upstream's version as each commit to the port's Makefile set it, or as this site first saw it in the system's packages; the tree's own revisions are not versions here.
Install
Binary package:
pkg install mysql84-server
From DPorts:
cd /usr/dports/databases/mysql84-server && make install clean
Dependency graph
Ports that need it on the left, what it needs to run on the right; at most 8 of each. "Dependencies" below lists them all.
graph LR
me["databases/mysql84-server"]
u0["comms/cqrlog"] --> me
u1["databases/akonadi"] --> me
u2["databases/percona-orchestrator"] --> me
u3["deskutils/moregroupware"] --> me
u4["net-mgmt/icingaweb2-module-x509"] --> me
u5["security/webfwlog"] --> me
u6["www/hotcrp"] --> me
me --> d0["archivers/liblz4"]
me --> d1["databases/mysql84-client"]
me --> d2["devel/icu"]
me --> d3["devel/libedit"]
me --> d4["devel/libunwind"]
me --> d5["devel/ncurses"]
me --> d6["ftp/curl"]
me --> d7["lang/gcc13"]
me -.-> dmore(["3 more"])
classDef this fill:#ab2b28,color:#ffffff,stroke:#ab2b28
class me this
There is no initial password for first time use of MySQL.
Keep in mind to reset it to a secure password.
MySQL 8.4 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.
MySQL Router is part of this package. It is disabled by default. To use it:
cp /usr/local/etc/mysqlrouter/mysqlrouter.conf.sample \
/usr/local/etc/mysqlrouter/mysqlrouter.conf
sysrc mysqlrouter_enable=YES
service mysqlrouter start
The router runs as the user "mysqlrouter" and logs to
/var/log/mysqlrouter/mysqlrouter.log. Do not add a "pid_file" or a "user"
entry to mysqlrouter.conf, the rc script takes care of both.
When creating a configuration for an InnoDB cluster, run
mysqlrouter --bootstrap --user=mysqlrouter, so that the generated
files below /var/db/mysqlrouter belong to that account.
If the router has to serve many connections, raise "openfiles" for its login
class in /etc/login.conf and point mysqlrouter_login_class in rc.conf at it,
upstream uses 10000.
The MySQL server performs all upgrade tasks itself at startup.
The mysql_upgrade utility does not exist anymore in MySQL 8.4.
This version adds an rc script, a configuration sample and the system user
"mysqlrouter" for MySQL Router. Nothing is enabled automatically.
If you already run MySQL Router yourself, note:
- An own /usr/local/etc/rc.d/mysqlrouter was renamed to mysqlrouter.pkgsave
by pkg and is not used anymore.
- An existing /var/log/mysqlrouter, /var/run/mysqlrouter or
/var/db/mysqlrouter is left untouched, ownership and permissions are not
changed. The rc script only creates the directories when they are
missing. If your router runs under a different account, set
mysqlrouter_user and mysqlrouter_group in rc.conf.
- /usr/local/etc/logrotate.d/mysqlrouter works from now on, its
"create 600 mysqlrouter mysqlrouter" no longer points at a missing user.
This site uses Google Analytics cookies to count visits and see which pages are read.
No cookie is set until you accept. What is collected