このページの2つのバージョン間の差分を表示します。
両方とも前のリビジョン 前のリビジョン 次のリビジョン | 前のリビジョン | ||
serverapps:db:mariadb [2018/06/13 23:02] hayashi [設定] |
serverapps:db:mariadb [2021/05/11 11:33] (現在) hayashi ↷ serverapps:mariadb から serverapps:db:mariadb へページを移動しました。 |
||
---|---|---|---|
行 11: | 行 11: | ||
以下を設定 | 以下を設定 | ||
- | | + | <file ini / |
- | default-character-set=utf8 | + | [client] |
- | [mysqld] | + | default-character-set=utf8 |
- | character_set_server = utf8 | + | [mysqld] |
+ | character_set_server = utf8 | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | <file ini / | ||
+ | mysql_enable=" | ||
+ | mysql_limits=" | ||
+ | # | ||
+ | # なお、dirを作成してパーミッションをmysql: | ||
+ | </ | ||
+ | |||
+ | ===== 起動 ===== | ||
+ | |||
+ | # service mysql-server start | ||
+ | |||
+ | ===== mysql_secure_installation ===== | ||
mysql_secure_installationを実行して、rootパスワードなどを設定する。((日本語部分は出力されません))((参考:https:// | mysql_secure_installationを実行して、rootパスワードなどを設定する。((日本語部分は出力されません))((参考:https:// | ||
行 134: | 行 151: | ||
MariaDB のご利用ありがとうございます! | MariaDB のご利用ありがとうございます! | ||
</ | </ | ||
+ | |||
+ | ===== 確認 ===== | ||
+ | |||
+ | $ mysql -u root -p | ||
+ | |||
+ | ==== 状態確認 ==== | ||
+ | < | ||
+ | MariaDB [(none)]> | ||
+ | -------------- | ||
+ | mysql Ver 15.1 Distrib 10.2.15-MariaDB, | ||
+ | |||
+ | Connection id: 12 | ||
+ | Current database: | ||
+ | Current user: | ||
+ | SSL: Not in use | ||
+ | Current pager: | ||
+ | Using outfile: | ||
+ | Using delimiter: | ||
+ | Server: | ||
+ | Server version: | ||
+ | Protocol version: | ||
+ | Connection: | ||
+ | Server characterset: | ||
+ | Db | ||
+ | Client characterset: | ||
+ | Conn. characterset: | ||
+ | UNIX socket: | ||
+ | Uptime: | ||
+ | |||
+ | Threads: 8 Questions: 15 Slow queries: 0 Opens: 17 Flush tables: 1 Open tables: 11 Queries per second avg: 0.010 | ||
+ | -------------- | ||
+ | </ | ||
+ | |||
+ | ==== プラグイン ==== | ||
+ | |||
+ | |||
+ | < | ||
+ | MariaDB [(none)]> | ||
+ | +-------------------------------+----------+--------------------+---------+---------+ | ||
+ | | Name | Status | ||
+ | +-------------------------------+----------+--------------------+---------+---------+ | ||
+ | | binlog | ||
+ | | mysql_native_password | ||
+ | | mysql_old_password | ||
+ | | wsrep | ACTIVE | ||
+ | | CSV | ACTIVE | ||
+ | | MEMORY | ||
+ | | MyISAM | ||
+ | | MRG_MyISAM | ||
+ | | CLIENT_STATISTICS | ||
+ | | INDEX_STATISTICS | ||
+ | | TABLE_STATISTICS | ||
+ | | USER_STATISTICS | ||
+ | | InnoDB | ||
+ | | INNODB_TRX | ||
+ | | INNODB_LOCKS | ||
+ | | INNODB_LOCK_WAITS | ||
+ | | INNODB_CMP | ||
+ | | INNODB_CMP_RESET | ||
+ | | INNODB_CMPMEM | ||
+ | | INNODB_CMPMEM_RESET | ||
+ | | INNODB_CMP_PER_INDEX | ||
+ | | INNODB_CMP_PER_INDEX_RESET | ||
+ | | INNODB_BUFFER_PAGE | ||
+ | | INNODB_BUFFER_PAGE_LRU | ||
+ | | INNODB_BUFFER_POOL_STATS | ||
+ | | INNODB_METRICS | ||
+ | | INNODB_FT_DEFAULT_STOPWORD | ||
+ | | INNODB_FT_DELETED | ||
+ | | INNODB_FT_BEING_DELETED | ||
+ | | INNODB_FT_CONFIG | ||
+ | | INNODB_FT_INDEX_CACHE | ||
+ | | INNODB_FT_INDEX_TABLE | ||
+ | | INNODB_SYS_TABLES | ||
+ | | INNODB_SYS_TABLESTATS | ||
+ | | INNODB_SYS_INDEXES | ||
+ | | INNODB_SYS_COLUMNS | ||
+ | | INNODB_SYS_FIELDS | ||
+ | | INNODB_SYS_FOREIGN | ||
+ | | INNODB_SYS_FOREIGN_COLS | ||
+ | | INNODB_SYS_TABLESPACES | ||
+ | | INNODB_SYS_DATAFILES | ||
+ | | INNODB_SYS_VIRTUAL | ||
+ | | INNODB_MUTEXES | ||
+ | | INNODB_SYS_SEMAPHORE_WAITS | ||
+ | | INNODB_TABLESPACES_ENCRYPTION | ACTIVE | ||
+ | | INNODB_TABLESPACES_SCRUBBING | ||
+ | | Aria | ACTIVE | ||
+ | | PERFORMANCE_SCHEMA | ||
+ | | SEQUENCE | ||
+ | | FEEDBACK | ||
+ | | user_variables | ||
+ | | partition | ||
+ | +-------------------------------+----------+--------------------+---------+---------+ | ||
+ | </ | ||
+ | |||
+ |