https://gist.github.com/meech-ward/db3597795904584b83a0cfa79b461b7d
Install MySQL and start it using the following commands
sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
sudo yum localinstall -y mysql57-community-release-el7-8.noarch.rpm
sudo yum install -y mysql-community-server
sudo systemctl start mysqld
sudo systemctl enable mysqld
Get the password for the root user:
sudo grep 'temporary password' /var/log/mysqld.log
Login to MySQL:
mysql -u root -p
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 'MyNewPass1!';
upload the sql file
Create a new user called sam with the password MyNewPass1! that can access the database from localhost:
CREATE USER 'sam'@'localhost' IDENTIFIED WITH mysql_native_password BY 'MyNewPass1!';
GRANT ALL PRIVILEGES ON lotr.* TO 'sam'@'localhost';
Now we can access the database with this user from the ec2 instance. So If I installed a web app on this instance, I could use this username and password.
However, if you want to be able to access the database from anywhere else, First, we have to create a new user that can access this database from any host.
CREATE USER 'frodo'@'%' IDENTIFIED WITH mysql_native_password BY 'MyNewPass1!';
GRANT ALL PRIVILEGES ON *.* TO 'frodo'@'%';