![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
&tag(MacPorts/mysql8);
sudo port uninstall mysql55-server
sudo port install mysql8-server
Warning: ----------------------------------------------------------------------- Warning: The port 'mysql8' uses the cxx11 PortGroup which is deprecated. Warning: Please instead specify the required c++ standard directly using Warning: compiler.cxx_standard 2011 Warning: replacing 2011 with newer standards (e.g. 2014, 2017) as required. Warning: For more details see https://trac.macports.org/wiki/CompilerSelection Warning: -----------------------------------------------------------------------
---> Some of the ports you installed have notes:
mysql8 has the following notes:
On activation if no /opt/local/etc/mysql8/my.cnf file exists one
will be created which loads
/opt/local/etc/mysql8/macports-default.cnf.
If a /opt/local/etc/mysql8/my.cnf file exists MacPorts does not
touch it and any changes you make to /opt/local/etc/mysql8/my.cnf
will be preserved (e.g., during port upgrades, deactivations or
activations). /opt/local/etc/mysql8/my.cnf is a good place to
customize your mysql8 installation.
Any changes made to /opt/local/etc/mysql8/macports-default.cnf
will be lost during port upgrades, deactivations or activations so you
are advised to not make changes here. Currently
/opt/local/etc/mysql8/macports-default.cnf contains only one
directive; to disable networking. With disabled networking it is
possible to install and have running all the MacPorts mysql ports
simultaneously.
To set mysql8 as your preferred version of MySQL, use `port select`,
as follows:
$ sudo port select mysql mysql8
mysql8-server has the following notes:
If this is a new install you might want to run:
$ sudo /opt/local/lib/mysql8/bin/mysqld --initialize --user=_mysql
$ sudo port load mysql8-server
$ /opt/local/lib/mysql8/bin/mysql_secure_installation
The first command creates the necessary files for the MySQL database service.
(Remember to make a note of the auto-generated root password from this step.)
The second command starts the MySQL service.
The last command helps to improve the security of your running MySQL instance.
Once enabled, the MySQL logs can be found in:
/opt/local/var/log/mysql8
# /opt/local/lib/mysql8/bin/mysqld --initialize --user=_mysql
# port load mysql8-server
# /opt/local/lib/mysql8/bin/mysql_secure_installation
!include /opt/local/etc/mysql8/macports-default.cnf [mysqld] skip-networking=0 collation-server=utf8mb4_bin
# Use default MacPorts settings #!include /opt/local/etc/mysql8/macports-default.cnf [client] default-character-set=utf8mb4 [mysqld] basedir="/opt/local" character-set-server=utf8mb4 max_allowed_packet = 32M [mysqldump] default-character-set=utf8mb4 [mysql] default-character-set=utf8mb4
ld: library not found for -lzstd
bundle config --local build.mysql2 "--with-ldflags=-L/opt/local/lib"
[ERROR] [MY-010338] [Server] Can't find error-message file '/opt/local/lib/mysql8/share/mysql8/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
[mysqld] basedir="/opt/local"
