Open5

phpMyAdmin構築(Ubuntu22.04)

shuichishuichi

Linux基本設定

sudo apt update -y
sudo apt upgrade -y

sudo timedatectl set-timezone Asia/Tokyo # Timezone設定
sudo timedatectl # 確認

sudo reboot
shuichishuichi

Install Apache2

sudo apt install -y apache2

sudo cp /etc/apache2/sites-available/000-default.conf /etc/apache2/sites-available/000-default.conf.original # 念のため

sed -i".original" -e "s/ServerAdmin.*/ServerAdmin <server-admin-mailaddress>/"

/etc/apache2/sites-available/000-default.confのServerAdminパラメータは、
リンクを張る

http(s)://<server-address>/

shuichishuichi

Install php

sudo apt install -y php libapache2-mod-php
#  -> Pending kernel upgrade
#  -> Daemons using outdated libraries

sudo systemctl restart apache2.service

sudo cat <<EOS | sudo tee /var/www/html/phpinfo.php
<?php
  phpinfo();
?>
EOS

http(s)://<server-address>/phpinfo.phpにアクセスして、phpinfoが表示されればOK。

sudo rm /var/www/html/phpinfo.php
shuichishuichi

Install phpMyAdmin

sudo apt install -y php-mbstring php-zip php-gd php-mysql
#  -> Pending kernel upgrade
#  -> Daemons using outdated libraries

sudo apt install -y phpmyadmin
#  -> Configuring phpmyadmin
#     -> apache2
#  -> Configuring phpmyadmin (dbconfig-common)
#     -> No
#  -> Pending kernel upgrade

sudo reboot

sudo systemctl restart apache2.service

http(s)://<server-address>/phpmyadmin/にアクセスして、phpMyAdminのログイン画面が表示されればOK。

ただし、DBの設定をしていないので、ログイン以降の操作はできない。

dbconfig-common

sudo cp /etc/dbconfig-common/phpmyadmin.conf /etc/dbconfig-common/phpmyadmin.conf.original

sudo sed -i".original" -e "s/dbc_upgrade='true'/dbc_upgrade='false'/" /etc/dbconfig-common/phpmyadmin.conf
sudo sed -i".original" -e "s/dbc_remove='true'/dbc_remove='false'/" /etc/dbconfig-common/phpmyadmin.conf
sudo sed -i".original" -e "s/dbc_dbuser=''/dbc_dbuser='<user-name>'/" /etc/dbconfig-common/phpmyadmin.conf
sudo sed -i".original" -e "s/dbc_dbpass=''/dbc_dbpass='<user-password>'/" /etc/dbconfig-common/phpmyadmin.conf
sudo sed -i".original" -e "s/dbc_dbserver='localhost'/dbc_dbserver='<db-address>'/" /etc/dbconfig-common/phpmyadmin.conf

sudo cp /etc/phpmyadmin/config.inc.php /etc/phpmyadmin/config.inc.php.original
sudo vim /etc/phpmyadmin/config.inc.php