gsp306
컨텐츠 정보
- 2,565 조회
- 0 추천
- 목록
본문
```
export ZONE=us-central1-a
gcloud sql instances create wordpress --tier=db-n1-standard-1 --activation-policy=ALWAYS --gce-zone $ZONE
gcloud sql users set-password --host % root --instance wordpress --password Password1*
export ADDRESS=
gcloud compute ssh blog --zone=us-central1-a
gcloud sql instances patch wordpress --authorized-networks $ADDRESS --quiet
MYSQLIP=$(gcloud sql instances describe wordpress --format="value(ipAddresses.ipAddress)")
mysql --host=[INSTANCE_IP_ADDR] \
--user=root --password
CREATE DATABASE wordpress;
CREATE USER 'blogadmin'@'%' IDENTIFIED BY 'Password1*';
GRANT ALL PRIVILEGES ON wordpress.* TO 'blogadmin'@'%';
FLUSH PRIVILEGES;
exit
sudo mysqldump -u root -pPassword1* wordpress > wordpress_backup.sql
mysql --host=$MYSQLIP --user=root -pPassword1* --verbose wordpress < wordpress_backup.sql
sudo service apache2 restart
cd /var/www/html/wordpress
sudo nano wp-config.php
```
관련자료
댓글 0
등록된 댓글이 없습니다.
