WordPressが使用するMariaDBをインストールします。
WordPress向けの設定は、次の章を参照ください。
インストール
$ sudo apt-get -y install mariadb-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
galera-4 gawk libcgi-fast-perl libcgi-pm-perl libclone-perl libconfig-inifiles-perl libdbd-mariadb-perl libdbi-perl libencode-locale-perl libfcgi-bin libfcgi-perl libfcgi0t64 libhtml-parser-perl libhtml-tagset-perl
libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-compress-brotli-perl libio-html-perl liblsof0 liblwp-mediatypes-perl liblzo2-2 libmariadb3 libncurses6 libpcre2-posix3 libsigsegv2 libsnappy1v5 libterm-readkey-perl
libtimedate-perl liburi-perl liburing2 lsof mariadb-client mariadb-client-core mariadb-common mariadb-plugin-provider-bzip2 mariadb-plugin-provider-lz4 mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo
mariadb-plugin-provider-snappy mariadb-server-core mysql-common pv socat
Suggested packages:
gawk-doc libmldbm-perl libnet-daemon-perl libsql-statement-perl libdata-dump-perl libipc-sharedcache-perl libbusiness-isbn-perl libmime-base32-perl libregexp-ipv6-perl libwww-perl mailx mariadb-test doc-base
The following NEW packages will be installed:
galera-4 gawk libcgi-fast-perl libcgi-pm-perl libclone-perl libconfig-inifiles-perl libdbd-mariadb-perl libdbi-perl libencode-locale-perl libfcgi-bin libfcgi-perl libfcgi0t64 libhtml-parser-perl libhtml-tagset-perl
libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-compress-brotli-perl libio-html-perl liblsof0 liblwp-mediatypes-perl liblzo2-2 libmariadb3 libncurses6 libpcre2-posix3 libsigsegv2 libsnappy1v5 libterm-readkey-perl
libtimedate-perl liburi-perl liburing2 lsof mariadb-client mariadb-client-core mariadb-common mariadb-plugin-provider-bzip2 mariadb-plugin-provider-lz4 mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo
mariadb-plugin-provider-snappy mariadb-server mariadb-server-core mysql-common pv socat
0 upgraded, 45 newly installed, 0 to remove and 0 not upgraded.
Need to get 19.8 MB of archives.
After this operation, 205 MB of additional disk space will be used.
Get:1 http://deb.debian.org/debian trixie/main arm64 galera-4 arm64 26.4.23-0+deb13u1 [774 kB]
Get:2 http://deb.debian.org/debian trixie/main arm64 libsigsegv2 arm64 2.14-1+b2 [34.3 kB]
Get:3 http://deb.debian.org/debian trixie/main arm64 gawk arm64 1:5.2.1-2+b2 [644 kB]
Get:4 http://deb.debian.org/debian trixie/main arm64 mysql-common all 5.8+1.1.1 [6,784 B]
Get:5 http://deb.debian.org/debian trixie/main arm64 mariadb-common all 1:11.8.3-0+deb13u1 [28.8 kB]
Get:6 http://deb.debian.org/debian trixie/main arm64 libdbi-perl arm64 1.647-1 [856 kB]
Get:7 http://deb.debian.org/debian trixie/main arm64 liblsof0 arm64 4.99.4+dfsg-2 [128 kB]
Get:8 http://deb.debian.org/debian trixie/main arm64 lsof arm64 4.99.4+dfsg-2 [306 kB]
Get:9 http://deb.debian.org/debian trixie/main arm64 libconfig-inifiles-perl all 3.000003-3 [44.8 kB]
Get:10 http://deb.debian.org/debian trixie/main arm64 libmariadb3 arm64 1:11.8.3-0+deb13u1 [175 kB]
Get:11 http://deb.debian.org/debian trixie/main arm64 libncurses6 arm64 6.5+20250216-2 [96.1 kB]
Get:12 http://deb.debian.org/debian trixie/main arm64 mariadb-client-core arm64 1:11.8.3-0+deb13u1 [885 kB]
Get:13 http://deb.debian.org/debian trixie/main arm64 libpcre2-posix3 arm64 10.46-1~deb13u1 [64.1 kB]
Get:14 http://deb.debian.org/debian trixie/main arm64 liburing2 arm64 2.9-1 [26.2 kB]
Get:15 http://deb.debian.org/debian trixie/main arm64 mariadb-client arm64 1:11.8.3-0+deb13u1 [3,056 kB]
Get:16 http://deb.debian.org/debian trixie/main arm64 mariadb-server-core arm64 1:11.8.3-0+deb13u1 [7,358 kB]
Get:17 http://deb.debian.org/debian trixie/main arm64 socat arm64 1.8.0.3-1 [411 kB]
Get:18 http://deb.debian.org/debian trixie/main arm64 mariadb-server arm64 1:11.8.3-0+deb13u1 [3,653 kB]
Get:19 http://deb.debian.org/debian trixie/main arm64 libhtml-tagset-perl all 3.24-1 [14.7 kB]
Get:20 http://deb.debian.org/debian trixie/main arm64 liburi-perl all 5.30-1 [105 kB]
Get:21 http://deb.debian.org/debian trixie/main arm64 libhtml-parser-perl arm64 3.83-1+b2 [97.5 kB]
Get:22 http://deb.debian.org/debian trixie/main arm64 libcgi-pm-perl all 4.68-1 [217 kB]
Get:23 http://deb.debian.org/debian trixie/main arm64 libfcgi0t64 arm64 2.4.5-0.1 [25.0 kB]
Get:24 http://deb.debian.org/debian trixie/main arm64 libfcgi-perl arm64 0.82+ds-3+b2 [24.4 kB]
Get:25 http://deb.debian.org/debian trixie/main arm64 libcgi-fast-perl all 1:2.17-1 [11.8 kB]
Get:26 http://deb.debian.org/debian trixie/main arm64 libclone-perl arm64 0.47-1+b1 [13.7 kB]
Get:27 http://deb.debian.org/debian trixie/main arm64 libdbd-mariadb-perl arm64 1.22-1+b4 [88.6 kB]
Get:28 http://deb.debian.org/debian trixie/main arm64 libencode-locale-perl all 1.05-3 [12.9 kB]
Get:29 http://deb.debian.org/debian trixie/main arm64 libfcgi-bin arm64 2.4.5-0.1 [11.9 kB]
Get:30 http://deb.debian.org/debian trixie/main arm64 libhtml-template-perl all 2.97-2 [66.5 kB]
Get:31 http://deb.debian.org/debian trixie/main arm64 libtimedate-perl all 2.3300-2 [39.3 kB]
Get:32 http://deb.debian.org/debian trixie/main arm64 libhttp-date-perl all 6.06-1 [10.7 kB]
Get:33 http://deb.debian.org/debian trixie/main arm64 libio-html-perl all 1.004-3 [16.2 kB]
Get:34 http://deb.debian.org/debian trixie/main arm64 liblwp-mediatypes-perl all 6.04-2 [20.2 kB]
Get:35 http://deb.debian.org/debian trixie/main arm64 libhttp-message-perl all 7.00-2 [79.8 kB]
Get:36 http://deb.debian.org/debian trixie/main arm64 libio-compress-brotli-perl arm64 0.004001-2+b3 [16.8 kB]
Get:37 http://deb.debian.org/debian trixie/main arm64 liblzo2-2 arm64 2.10-3+b1 [49.6 kB]
Get:38 http://deb.debian.org/debian trixie/main arm64 libsnappy1v5 arm64 1.2.2-1 [28.3 kB]
Get:39 http://deb.debian.org/debian trixie/main arm64 libterm-readkey-perl arm64 2.38-2+b4 [24.5 kB]
Get:40 http://deb.debian.org/debian trixie/main arm64 mariadb-plugin-provider-bzip2 arm64 1:11.8.3-0+deb13u1 [29.5 kB]
Get:41 http://deb.debian.org/debian trixie/main arm64 mariadb-plugin-provider-lz4 arm64 1:11.8.3-0+deb13u1 [29.4 kB]
Get:42 http://deb.debian.org/debian trixie/main arm64 mariadb-plugin-provider-lzma arm64 1:11.8.3-0+deb13u1 [29.4 kB]
Get:43 http://deb.debian.org/debian trixie/main arm64 mariadb-plugin-provider-lzo arm64 1:11.8.3-0+deb13u1 [29.4 kB]
Get:44 http://deb.debian.org/debian trixie/main arm64 mariadb-plugin-provider-snappy arm64 1:11.8.3-0+deb13u1 [29.4 kB]
Get:45 http://deb.debian.org/debian trixie/main arm64 pv arm64 1.9.31-1 [111 kB]
Fetched 19.8 MB in 2s (10.2 MB/s)
Extracting templates from packages: 100%
Preconfiguring packages ...
Selecting previously unselected package galera-4.
(Reading database ... 73068 files and directories currently installed.)
Preparing to unpack .../galera-4_26.4.23-0+deb13u1_arm64.deb ...
Unpacking galera-4 (26.4.23-0+deb13u1) ...
Selecting previously unselected package libsigsegv2:arm64.
Preparing to unpack .../libsigsegv2_2.14-1+b2_arm64.deb ...
Unpacking libsigsegv2:arm64 (2.14-1+b2) ...
Setting up libsigsegv2:arm64 (2.14-1+b2) ...
Selecting previously unselected package gawk.
(Reading database ... 73087 files and directories currently installed.)
Preparing to unpack .../00-gawk_1%3a5.2.1-2+b2_arm64.deb ...
Unpacking gawk (1:5.2.1-2+b2) ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../01-mysql-common_5.8+1.1.1_all.deb ...
Unpacking mysql-common (5.8+1.1.1) ...
Selecting previously unselected package mariadb-common.
・
・
・インストールのバージョンは
$ sudo mysqladmin version
mysqladmin from 11.8.3-MariaDB, client 10.0 for debian-linux-gnu (aarch64)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version 11.8.3-MariaDB-0+deb13u1 from Debian
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /run/mysqld/mysqld.sock
Uptime: 1 min 15 sec
Threads: 1 Questions: 58 Slow queries: 0 Opens: 33 Open tables: 26 Queries per second avg: 0.773で確認します。
ももぶろ
WordPress固有の設定は、後で書きます。
