差分
このページの2つのバージョン間の差分を表示します。
両方とも前のリビジョン 前のリビジョン 次のリビジョン | 前のリビジョン 次のリビジョン両方とも次のリビジョン | ||
ja:documentation:07_technical_annexes:19_mysql_8 [2022/12/02 08:27] – [Rocky Linux 8/AlmaLinux 8/RHEL 8] junichi | ja:documentation:07_technical_annexes:19_mysql_8 [2023/01/31 05:48] – [Rocky Linux 8/AlmaLinux 8/RHEL 8] junichi | ||
---|---|---|---|
行 148: | 行 148: | ||
</ | </ | ||
+ | |||
+ | * If **you do not have an HA environment**, | ||
+ | |||
+ | * **HA 環境が無い場合**は、'' | ||
+ | |||
+ | < | ||
+ | skip-log-bin | ||
+ | |||
+ | </ | ||
+ | |||
+ | <WRAP center round tip 60%> | ||
+ | |||
+ | See also " | ||
+ | |||
+ | </ | ||
+ | |||
+ | <WRAP center round tip 60%> | ||
+ | |||
+ | '' | ||
+ | |||
+ | </ | ||
* Start the MySQL service: | * Start the MySQL service: | ||
行 197: | 行 218: | ||
< | < | ||
- | # mysql -u root -p pandora | + | mysql -u root -p pandora |
- | > drop database pandora; | + | |
- | > create database pandora; | + | |
- | > use pandora; | + | |
- | > source / | + | |
- | > source backup_pandora.sql; | + | |
</ | </ | ||
+ | |||
+ | < | ||
+ | drop database pandora; | ||
+ | create database pandora; | ||
+ | use pandora; | ||
+ | source / | ||
+ | source backup_pandora.sql; | ||
+ | |||
+ | </ | ||
+ | |||
+ | * The necessary permissions (grants) must be added again; //if you are not logged in// to '' | ||
+ | |||
+ | * 必要なアクセス許可を再度追加する必要があります。 '' | ||
+ | |||
+ | < | ||
+ | mysql -u root -p < | ||
+ | |||
+ | </ | ||
+ | |||
+ | * **Once logged in as root execute the following commands:** | ||
+ | * Deactivate the password validation plugin (optional). | ||
+ | |||
+ | * **root としてログインしてら次のコマンドを実行します。** | ||
+ | * パスワード検証プラグインを無効にします(オプション)。 | ||
+ | |||
+ | < | ||
+ | UNINSTALL COMPONENT ' | ||
+ | |||
+ | </ | ||
+ | |||
+ | * Create the login user if it does not exist: | ||
+ | |||
+ | * ログインユーザが存在しない場合は作成します。 | ||
+ | |||
+ | < | ||
+ | CREATE USER "< | ||
+ | |||
+ | </ | ||
+ | |||
+ | <WRAP center round tip 60%> | ||
+ | |||
+ | // | ||
+ | |||
+ | </ | ||
+ | |||
+ | <WRAP center round tip 60%> | ||
+ | |||
+ | // | ||
+ | |||
+ | </ | ||
+ | |||
+ | * Assign the native password for '' | ||
+ | |||
+ | * '' | ||
+ | |||
+ | < | ||
+ | ALTER USER "< | ||
+ | |||
+ | </ | ||
+ | |||
+ | * Grant grants on Pandora FMS database ('' | ||
+ | |||
+ | * Pandora FMS データベース('' | ||
+ | |||
+ | < | ||
+ | GRANT ALL PRIVILEGES ON pandora.* TO "< | ||
+ | |||
+ | </ | ||
+ | |||
+ | * Save the changes and exit: | ||
+ | |||
+ | * 変更を保存して抜けます。 | ||
+ | |||
+ | < | ||
+ | flush privileges; | ||
+ | exit | ||
+ | |||
+ | </ | ||
+ | |||
+ | Once you have finished working with the database, perform the following steps: | ||
+ | |||
+ | データベースの対応が完了したら、次のステップを実行します。 | ||
* Start the PFMS server and the PFMS Software Agent: | * Start the PFMS server and the PFMS Software Agent: | ||
行 338: | 行 436: | ||
</ | </ | ||
+ | |||
+ | * If **you do not have an HA environment**, | ||
+ | |||
+ | * **HA 環境が無い場合**は、'' | ||
+ | |||
+ | < | ||
+ | skip-log-bin | ||
+ | |||
+ | </ | ||
+ | |||
+ | <WRAP center round tip 60%> | ||
+ | |||
+ | See also " | ||
+ | |||
+ | </ | ||
+ | |||
+ | <WRAP center round tip 60%> | ||
+ | |||
+ | '' | ||
+ | |||
+ | </ | ||
* Start the MySQL service: | * Start the MySQL service: | ||
行 387: | 行 506: | ||
< | < | ||
- | # mysql -u root -p pandora | + | mysql -u root -p pandora |
- | > drop database pandora; | + | |
- | > create database pandora; | + | </code> |
- | > use pandora; | + | |
- | > source / | + | < |
- | > source backup_pandora.sql; | + | drop database pandora; |
+ | create database pandora; | ||
+ | use pandora; | ||
+ | source / | ||
+ | source backup_pandora.sql; | ||
</ | </ |