AWS構築手順

■EC2
user:ec2-user/パスワード無し　※鍵あり

・update
sudo yum update
sudo yum install git -y

git clone https://github.com/yyuu/pyenv.git ~/.pyenv

echo 'export PYENV_ROOT="$HOME/.pyenv"' >> ~/.bash_profile
echo 'export PATH="$PYENV_ROOT/bin:$PATH"' >> ~/.bash_profile
echo 'eval "$(pyenv init -)"' >> ~/.bash_profile
source ~/.bash_profile

sudo yum install gcc zlib-devel bzip2 bzip2-devel readline readline-devel sqlite sqlite-devel openssl openssl-devel libffi-devel -y

pyenv install 3.9.4
pyenv global 3.9.4
pyenv rehash

pip install --upgrade pip
sudo yum install python-devel mysql-devel -y
pip install mysqlclient

pip install django

・ユーザ作成
sudo su -
password
xxxxx

sudo useradd comutars
sudo cp -arp /home/ec2-user/.ssh /home/comutars
sudo chowm -R comutars /home/comutars/.ssh

sudo visudo -f /etc/sudoers.d/90-cloud-init-users

#ec2 -user ALL=(ALL) NOPASSWD:ALL
comutars ALL=(ALL) NOPASSWD:ALL

・Httpdインストール
sudo yum -y install httpd
sudo systemctl start httpd

・mysqlインストール
sudo yum localinstall -y https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm
sudo yum install -y mysql-community-server
sudo systemctl start mysqld
sudo systemctl status mysqld

・パスワード調査
grep password /var/log/mysqld.log
j?=hlp>Uk7!r

CREATE USER 'dpass'@'192.168.1.%' IDENTIFIED BY 'xxxxxx#';
CREATE USER 'root'@'192.168.1.%' IDENTIFIED BY 'xxxxxx#';

grant all privileges on dpass_db.* to root@'192.168.1.%';
grant all privileges on dpass_db.* to dpass@'192.168.1.%';
grant all privileges on dpass_db.* to xxxxx@'localhost';

CREATE USER 'dpass'@'%' IDENTIFIED BY 'xxxxx';
GRANT ALL PRIVILEGES ON xxxx_db.* TO 'xxxxx'@'%';

ストアド利用権限
SHOW VARIABLES LIKE 'log_bin_trust_function_creators';
set global log_bin_trust_function_creators=1;
SHOW VARIABLES LIKE 'log_bin_trust_function_creators';

・djangoインストール
pip install django
cd /home
django-admin startproject xxxxx

# django-admin startproject config .
# python manage.py startapp app
# python manage.py makemigrations
# python manage.py migrate
# python manage.py createsuperuser
ユーザパスワード admin/xxxxxメール xx@xxxxxxx.co.jp

# yum install -y httpd httpd-devel
# yum groupinstall "Development tools"
# yum install gcc zlib-devel bzip2 bzip2-devel readline readline-devel sqlite sqlite-devel openssl openssl-devel git
# pip install wheel
# pip install mod_wsgi
# pip install mod_wsgi-httpd

# env PYTHON_CONFIGURE_OPTS="--enable-shared" pyenv install 3.9.4
# pip install mod_wsgi

#vi /etc/httpd/conf.d/wsgi.conf
LoadModule wsgi_module /home/comutars/.pyenv/versions/3.9.4/lib/python3.9/site-packages/mod_wsgi/server/mod_wsgi-py39.cpython-39-x86_64-linux-gnu.so
WSGIScriptAlias / /home/dpass/config/wsgi.py
WSGIPythonPath /home/xxxxx:/home/xxxxx/config/:/home/xxxxx/.pyenv/versions/3.9.4/lib/python3.9/site-packages:/home/xxxxx/.pyenv/versions/3.9.4/lib/python3.9/site-packages/django/contrib/admin

<Directory /home/xxxxx/config>
<Files wsgi.py>
Require all granted
</Files>
</Directory>

Alias /static/ /home/xxxxx/static/
<Directory /home/xxxxx/static>
Require all granted
</Directory>

■アプリ
・model.pyを作成
・テーブルの作成
https://qiita.com/okoppe8/items/c9f8372d5ac9a9679396