kingoamino

# Show the default password for root user

grep "A temporary password" /var/log/mysqld.log

# MySQL Secure Installation

mysql_secure_installation


# Remove anonymous users? (Press y|Y for Yes, any other key for No) : y

kingoamino

# Setup Yum repository
rpm -Uvh https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm

# Install MySQL 8 Community Server
sed -i 's/enabled=1/enabled=0/' /etc/yum.repos.d/mysql-community.repo

# Install MySQL
yum --enablerepo=mysql80-community install mysql-community-server -y

# Start MySQL Service

kingoamino

# install git
yum  -y install git

# clone WordPress from repo
git clone https://github.com/WordPress/WordPress.git

kingoamino

#Update CentOS
Yum -y update

# Install Wget 
yum -y install wget

# Enable the PHP 7.3 Remi repository
wget -q http://rpms.remirepo.net/enterprise/remi-release-7.rpm
wget -q https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

kingoamino

# Install Apache
yum update -y
yum install httpd -y
systemctl start httpd.service

# Enable Apache to start at server boot
systemctl enable httpd.service

# for EC2 & RDS Database 
setsebool httpd_can_network_connect_db 1

kingoamino

# Create a dump to Dump_date.sql
mysqldump --databases -h 'host_DB' 'DataBase name' -u 'User' -p 'Passwd' > /var/www/BackUP/Dump_$(date +"%m-%d-%y").sql

kingoamino

zip -r /var/www/BackUP/wordpress-$(date +"%m-%d-%y").zip /var/www/html/WordPress

kingoamino

echo "<?php phpinfo(); ?>" > /var/www/html/info.php

kingoamino

----------------------------------------------------------------------------------------
OS/Distro             |	  Official AMI  |   Legacy / Community / Other AMI ssh Username |
----------------------------------------------------------------------------------------
Amazon Linux          |   ec2-user      |                                               |
Ubuntu                |   ubuntu        |   root                                        |
Debian                |   admin         |   root                                        |
RHEL 6.4 and later    |   ec2-user      |                                               |
RHEL 6.3 and earlier  |   root          |                                               |
Fedora                |   fedora        |   ec2-user, root                              |
Centos	              |   centos        |   root                                        |

kingoamino

sftp> help
Available commands:
bye                                Quit sftp
cd path                            Change remote directory to 'path'
chgrp grp path                     Change group of file 'path' to 'grp'
chmod mode path                    Change permissions of file 'path' to 'mode'
chown own path                     Change owner of file 'path' to 'own'
df [-hi] [path]                    Display statistics for current directory or
                                   filesystem containing 'path'
exit                               Quit sftp