Скачать или смотреть Hosting MySQL Database on EC2 instance - Step by step guide

Guide on how you can host MySQL database on your EC2 instance.

1. Install MySQL and start it using the following commands
2. sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-my...
3. sudo wget http://dev.mysql.com/get/mysql57-comm...
4. sudo yum localinstall -y mysql57-community-release-el7-8.noarch.rpm
5. sudo yum install -y mysql-community-server
6. sudo systemctl start mysqld
7. sudo systemctl enable mysqld
8. Get the password for the root user:
9. sudo grep 'temporary password' /var/log/mysqld.log
10. Login to MySQL: mysql -u root -p
11. You have to change the root user's password before you can do anything, so run the following command to do that: ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Admin_123456';
12. upload/Create the SQL database.