MacPorts/mysql8
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
&tag(MacPorts/mysql8);
*目次 [#w448a619]
#contents
*関連ページ [#m4d68432]
*参考情報 [#d8ae446d]
*インストール [#haf1dd4a]
-mysql55-serverのアンインストール
sudo port uninstall mysql55-server
-mysql8-serverのインストール
sudo port install mysql8-server
-以下の警告が表示される(無視してOK?)
#pre{{
Warning: ------------------------------------------------...
Warning: The port 'mysql8' uses the cxx11 PortGroup which...
Warning: Please instead specify the required c++ standard...
Warning: compiler.cxx_standard 2011
Warning: replacing 2011 with newer standards (e.g. 2014, ...
Warning: For more details see https://trac.macports.org/w...
Warning: ------------------------------------------------...
}}
-以下のインストラクションが表示される
#pre{{
---> Some of the ports you installed have notes:
mysql8 has the following notes:
On activation if no /opt/local/etc/mysql8/my.cnf file...
will be created which loads
/opt/local/etc/mysql8/macports-default.cnf.
If a /opt/local/etc/mysql8/my.cnf file exists MacPort...
touch it and any changes you make to /opt/local/etc/m...
will be preserved (e.g., during port upgrades, deacti...
activations). /opt/local/etc/mysql8/my.cnf is a good ...
customize your mysql8 installation.
Any changes made to /opt/local/etc/mysql8/macports-de...
will be lost during port upgrades, deactivations or a...
are advised to not make changes here. Currently
/opt/local/etc/mysql8/macports-default.cnf contains o...
directive; to disable networking. With disabled netwo...
possible to install and have running all the MacPorts...
simultaneously.
To set mysql8 as your preferred version of MySQL, use...
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 ...
$ sudo port load mysql8-server
$ /opt/local/lib/mysql8/bin/mysql_secure_installation
The first command creates the necessary files for the...
(Remember to make a note of the auto-generated root p...
The second command starts the MySQL service.
The last command helps to improve the security of you...
Once enabled, the MySQL logs can be found in:
/opt/local/var/log/mysql8
}}
-要するに以下を実行する。最初にmy.cnfの設定か。sudoだとエ...
#pre{{
# /opt/local/lib/mysql8/bin/mysqld --initialize --use...
# port load mysql8-server
# /opt/local/lib/mysql8/bin/mysql_secure_installation
}}
-何かエラーが発生した場合、このページのトラブルシューティ...
-rootのデフォルトパスワードは、 「/opt/local/lib/mysql8/b...
-VALIDATE PASSWORDは向こうにする。
*設定 [#u11e42a8]
**my.cnfの編集 [#q02c4031]
-以下の内容におきかえ。デフォルトはネットワーク経由で接続...
#pre{{
!include /opt/local/etc/mysql8/macports-default.cnf
[mysqld]
skip-networking=0
collation-server=utf8mb4_bin
default_authentication_plugin=mysql_native_password
}}
-以下古い内容。
#pre{{
# 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
}}
*トラブルシューティング [#sc404e5e]
**rubyの"mysql2"がインストールできない [#ub308f45]
-以下のようなエラーが発生。
ld: library not found for -lzstd
-/opt/local/libの下にあるlibzstdを探してくれないらしい(フ...
-以下を実行したあとbundle installする。
bundle config --local build.mysql2 "--with-ldflags=-L/op...
** 「mysqld --initialize --user=_mysql」でエラー [#tde4c...
-/opt/local/lib/mysql8/bin/mysqld --initialize --user=_my...
#pre{{
[ERROR] [MY-010338] [Server] Can't find error-message fil...
}}
-原因1: my.cnfのbasedirを確認。以下の設定が有効じゃないと...
#pre{{
[mysqld]
basedir="/opt/local"
}}
-原因2: 初期化前に「sudo port unload mysql8-server」して...
# port unload mysql8-server
# rm -rf /opt/local/var/db/mysql8/*
# rm -rf /opt/local/var/db/mysql8/.*
# /opt/local/lib/mysql8/bin/mysqld --initialize --user=_...
終了行:
&tag(MacPorts/mysql8);
*目次 [#w448a619]
#contents
*関連ページ [#m4d68432]
*参考情報 [#d8ae446d]
*インストール [#haf1dd4a]
-mysql55-serverのアンインストール
sudo port uninstall mysql55-server
-mysql8-serverのインストール
sudo port install mysql8-server
-以下の警告が表示される(無視してOK?)
#pre{{
Warning: ------------------------------------------------...
Warning: The port 'mysql8' uses the cxx11 PortGroup which...
Warning: Please instead specify the required c++ standard...
Warning: compiler.cxx_standard 2011
Warning: replacing 2011 with newer standards (e.g. 2014, ...
Warning: For more details see https://trac.macports.org/w...
Warning: ------------------------------------------------...
}}
-以下のインストラクションが表示される
#pre{{
---> Some of the ports you installed have notes:
mysql8 has the following notes:
On activation if no /opt/local/etc/mysql8/my.cnf file...
will be created which loads
/opt/local/etc/mysql8/macports-default.cnf.
If a /opt/local/etc/mysql8/my.cnf file exists MacPort...
touch it and any changes you make to /opt/local/etc/m...
will be preserved (e.g., during port upgrades, deacti...
activations). /opt/local/etc/mysql8/my.cnf is a good ...
customize your mysql8 installation.
Any changes made to /opt/local/etc/mysql8/macports-de...
will be lost during port upgrades, deactivations or a...
are advised to not make changes here. Currently
/opt/local/etc/mysql8/macports-default.cnf contains o...
directive; to disable networking. With disabled netwo...
possible to install and have running all the MacPorts...
simultaneously.
To set mysql8 as your preferred version of MySQL, use...
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 ...
$ sudo port load mysql8-server
$ /opt/local/lib/mysql8/bin/mysql_secure_installation
The first command creates the necessary files for the...
(Remember to make a note of the auto-generated root p...
The second command starts the MySQL service.
The last command helps to improve the security of you...
Once enabled, the MySQL logs can be found in:
/opt/local/var/log/mysql8
}}
-要するに以下を実行する。最初にmy.cnfの設定か。sudoだとエ...
#pre{{
# /opt/local/lib/mysql8/bin/mysqld --initialize --use...
# port load mysql8-server
# /opt/local/lib/mysql8/bin/mysql_secure_installation
}}
-何かエラーが発生した場合、このページのトラブルシューティ...
-rootのデフォルトパスワードは、 「/opt/local/lib/mysql8/b...
-VALIDATE PASSWORDは向こうにする。
*設定 [#u11e42a8]
**my.cnfの編集 [#q02c4031]
-以下の内容におきかえ。デフォルトはネットワーク経由で接続...
#pre{{
!include /opt/local/etc/mysql8/macports-default.cnf
[mysqld]
skip-networking=0
collation-server=utf8mb4_bin
default_authentication_plugin=mysql_native_password
}}
-以下古い内容。
#pre{{
# 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
}}
*トラブルシューティング [#sc404e5e]
**rubyの"mysql2"がインストールできない [#ub308f45]
-以下のようなエラーが発生。
ld: library not found for -lzstd
-/opt/local/libの下にあるlibzstdを探してくれないらしい(フ...
-以下を実行したあとbundle installする。
bundle config --local build.mysql2 "--with-ldflags=-L/op...
** 「mysqld --initialize --user=_mysql」でエラー [#tde4c...
-/opt/local/lib/mysql8/bin/mysqld --initialize --user=_my...
#pre{{
[ERROR] [MY-010338] [Server] Can't find error-message fil...
}}
-原因1: my.cnfのbasedirを確認。以下の設定が有効じゃないと...
#pre{{
[mysqld]
basedir="/opt/local"
}}
-原因2: 初期化前に「sudo port unload mysql8-server」して...
# port unload mysql8-server
# rm -rf /opt/local/var/db/mysql8/*
# rm -rf /opt/local/var/db/mysql8/.*
# /opt/local/lib/mysql8/bin/mysqld --initialize --user=_...
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
