Yang's Blog

Yang's Blog

Cheatsheet for Installing MySQL on AWS

1. Create an AWS EC2 instance.

2. Connect to the instance.

3. Install MySQL


sudo su

yum install wget -y

wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

md5sum mysql80-community-release-el8-1.noarch.rpm

rpm -ivh rpm -ivh mysql80-community-release-el8-1.noarch.rpm

yum module disable mysql 
y

yum install mysql-community-server

systemctl start mysqld

systemctl status mysqld

ps -ef | grep mysql

cat /var/log/mysqld.log|grep temp

mysql -u root -p mysql

mysqladmin -u root -p password

mysql -u root -p mysql

select * from mysql.time_zone;

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
 
Share this