バーチャルホストで複数のWordPressを運用

C:\Program Files\MySQL\MySQL Server 8.0\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7341
Server version: 8.0.22 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database testdb;
Query OK, 1 row affected (0.01 sec)

mysql> create user 'testuser'@'localhost' identified by '**********';
Query OK, 0 rows affected (0.03 sec)

mysql> grant all on testdb.* to 'testuser'@'localhost';
Query OK, 0 rows affected (0.01 sec)

mysql> select user,host,plugin from mysql.user;
+------------------+-----------+-----------------------+
| user             | host      | plugin                |
+------------------+-----------+-----------------------+
| mysql.infoschema | localhost | caching_sha2_password |
| mysql.session    | localhost | caching_sha2_password |
| mysql.sys        | localhost | caching_sha2_password |
| root             | localhost | caching_sha2_password |
| testuser         | localhost | caching_sha2_password |
+------------------+-----------+-----------------------+
5 rows in set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
| testdb             |
+--------------------+
5 rows in set (0.01 sec)

mysql>

<Directory "D:/www/public_html">
    #
    Options FollowSymLinks ExecCGI
    Options +Includes
    #
    AllowOverride All
    Require all granted
</Directory>
#
<Directory "D:/www/testhost">
    #
    Options FollowSymLinks ExecCGI
    Options +Includes
    #
    AllowOverride All
    Require all granted
</Directory>

<VirtualHost *:80>
    ServerAdmin webmaster@hoge.com
    DocumentRoot "D:/www/public_html"
    ServerName hoge.com
    ServerAlias www.hoge.com
    ErrorLog "${SRVROOT}/logs/error.log"
    CustomLog "${SRVROOT}/logs/access.log" common
</VirtualHost>
#
<VirtualHost *:80>
    ServerAdmin webmaster@hoge.com
    DocumentRoot "D:/www/testhost"
    ServerName testhost.hoge.com
    ServerAlias www.testhost.hoge.com
    ErrorLog "${SRVROOT}/logs/error.log"
    CustomLog "${SRVROOT}/logs/access.log" common
</VirtualHost>

MDomain hoge.com testhost.hoge.com
<VirtualHost _default_:443>
#   General setup for the virtual host
DocumentRoot "D:/www/public_html"
ServerName hoge.com
ServerAlias www.hoge.com
ServerAdmin webmaster@hoge.com
ErrorLog "${SRVROOT}/logs/error.log"
TransferLog "${SRVROOT}/logs/access.log"
#   :
#   : 省略
#   :
</VirtualHost> 
#
<VirtualHost _default_:443>
DocumentRoot "D:/www/testhost"
ServerName testhost.hoge.com
ServerAlias www.testhost.hoge.com
ServerAdmin webmaster@hoge.com
ErrorLog "${SRVROOT}/logs/error.log"
TransferLog "${SRVROOT}/logs/access.log"
#   :
#   : 省略
#   :
</VirtualHost>
#
MDomain hoge.jp
<VirtualHost _default_:443>
DocumentRoot "D:/www/jp"
ServerName hoge.jp
ServerAlias www.hoge.jp
ServerAdmin webmaster@hoge.com
ErrorLog "${SRVROOT}/logs/error.log"
TransferLog "${SRVROOT}/logs/access.log"
 
SSLEngine on

#SSLCertificateFile "${SRVROOT}/conf/server.crt"
#
#SSLCertificateKeyFile "${SRVROOT}/conf/server.key"
#   :
#   : 省略
#   :
</VirtualHost>
#
<IfModule md_module>
MDBaseServer            off
MDCertificateProtocol   ACME
MDCAChallenges          http-01 tls-alpn-01
MDRenewMode             auto 
MDPrivateKeys           RSA 2048
MDRenewWindow           33%
MDStoreDir              md
# 
#MDCertificateAuthority https://acme-staging-v02.api.letsencrypt.org/directory
MDCertificateAuthority  https://acme-v02.api.letsencrypt.org/directory
MDCertificateAgreement  https://letsencrypt.org/documents/LE-SA-v1.2-November-15-7.pdf
</IfModule>